> 文章列表 / Page 328

Stored objects And Transient objects are stored in the library cache, neither Temporary objects nor Permanent objects. The library cache is structured as a Hash table .But Library cache objects are co...

X$BH Fixed Table Buffer Cache Diagram Column Type Description ~~~~~~ ~~~~~ ~~~~~~~~~~~ ADDR RAW(4) Hex address of the Buffer Header. INDX NUMBER Buffer Header number BUF# NUMBER HLADDR RAW(4) Hash Cha...

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

------------------------------------------------------------------------------- -- -- Script: rolling_back.sql -- Purpose: to predict when transactions will finish rolling back -- For: 9.0+ -- -- Copy...

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 rollback segment headers. The...

Error: ORA 10500 Text: turn on traces for SMON ------------------------------------------------------------------------------- Cause: Action: Level: <=5 trace instance recovery > 5 trace posting...

What is skip scanning? In prior releases, a composite index would be used to retrieve the records, if the index prefix (leading) column was included in the predicate of the statement. With Orac...

The change vectors as constructed by the transaction layer are used by the cache layer to apply the physical block changes. Redo log ordering and recovery as well as read consistency are the fundament...

Event:10211 See <Note:32969.1> for similar events / parameters ~~~~~~~~~~~ Version/Use: 7.0 - 8.1.7 Check data block integrity after each modification 9.0+ This event is no longer valid. Use &lt...

Event:10060 Text: dump predicates in optimizer (kko) ------------------------------------------------------------------------------- Explanation: This is a special EVENT code. It should *NOT* be used ...