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

摘要： Two purposes of latches were:Serialize Execution,Serialize AccessMatch the characteristics with latches and enqueues.Several modes of access EnqueueFIFO queue acquisition... 阅读全文

摘要： Error: ORA 10061Text: disable SMON from cleaning temp segment-------------------------------------------------------------------------------Explanation: This is NOT an error but is a special... 阅读全文

摘要： Error: ORA 10226Text: trace CR applications of undo for data operations-------------------------------------------------------------------------------Explanation: This is NOT an error but is... 阅读全文

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

摘要： 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... 阅读全文