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

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

摘要： Oracle8 has introduced a change with the data block cache header format. Thebasic idea is that incarnation and sequence numbers stored in the cache headerhave been replaced with an SCN number and seq... 阅读全文

摘要： PURPOSE-------The purpose of this article is to explain briefly the structure of the syntax toevent-based trace generation.Setting an event: The structure of the trace syntax--------------------------... 阅读全文

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

摘要： ----------------------------------------------------------------------------------- Script: rolling_back.sql-- Purpose: to predict when transactions will finish rolling back-- For: 9.0+---- Copyright... 阅读全文

摘要： 在测试ASMlib的时候出现了oracleasm无法创建磁盘的错误，具体如下:[root@vrh1 yum.repos.d]# /etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM li... 阅读全文

摘要： X$BH Fixed Table Buffer Cache DiagramColumn Type Description~~~~~~ ~~~~~ ~~~~~~~~~~~ADDR RAW(4) Hex address of the Buffer Header.INDX NUMBER Buffer Header numberBUF# NUMBE... 阅读全文

摘要： Event: 10231Text: skip corrupted blocks on _table_scans_-------------------------------------------------------------------------------Cause:Action: Corrupt blocks are skipped in table scans, and lis... 阅读全文