ORACLE数据库服务热线：13764045638 诗檀软件

摘要： Error: ORA 10500Text: turn on traces for SMON-------------------------------------------------------------------------------Cause:Action: Level: 5 trace posting of SMONTo set event 10500:... 阅读全文

摘要： View: X$KTUXE [K]ernel [T]ransaction [U]ndo Transa[x]tion [E]ntry (table) This view is very useful as it gives an indication of the state of the transaction tables in the rollbac... 阅读全文

摘要： Text: Stop SMON from cleaning up obj$-------------------------------------------------------------------------------NOTE:Events should NEVER be set by customers unless advised to do so byOracle Supp... 阅读全文

摘要： Event:10235 ~~~~~~~~~~~ Version/Use: 7.0 - 10.1.X Check memory manager internal structures. 7.0 - 10.1.X "Check memory manager internal structures" ~~~~~~~~~~~~~~~~~~~~~~~~~~... 阅读全文

摘要： Error: ORA 10051Text: trace OPI calls-------------------------------------------------------------------------------Explanation:This is NOT an error but is a special EVENT code.It should *NOT* be u... 阅读全文

摘要： View: X$KCCRS [K]ernel [C]ache [C]ontrolfile management controlfile [R]ecord [S]ection directory Column Type Description -------- ---- ----------- ... 阅读全文

摘要： From Vinod Haval's These Views helps in understanding the following metrics Physical Mapping Provides Undocumented Information 18 X$ Tables (May be more) TABLE NAMEDESCRIPTIONX$KFALSThis table gi... 阅读全文

摘要： Value Name(s) Table method (TM lock) 0 No lock n/a 1 Null lock (NL) Used during some parallel DML operations (e.g. update) by ... 阅读全文

摘要： 以下脚本用于列出Oracle中数据文件的状况:REM Datafile Reportset linesize 120 pagesize 1400;SELECT t.tablespace_name, 'Datafile' file_type, t.status tablespace_status, d.status file_status, ROUND... 阅读全文

摘要： 事件说明例子Event 10013 - Monitor Transaction Recovery在Startup时跟踪事务恢复ALTER SESSION SET EVENTS '10013 trace name context forever, level 1';Event 10015 - Dump Undo Segment Headers-在事务恢复后做Dump回退段头信息ALTER... 阅读全文