>ASKMACLEAN_

> 文章列表 / Page 330

2007-06-22

Oracle内部视图:X$BH

X$BH Fixed Table Buffer Cache Diagram Column Type Description ~~~~~~ ~~~~~ ~~~~~~~~~~~ ADDR RAW(4) Hex address of the Buffer Header.…
#POST 4 MIN READ
2007-04-25

oracleasm failed to createdisk on raw device

在测试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…
#POST 1 MIN READ
2007-04-19

Script:when transaction will finish rollback

------------------------------------------------------------------------------- -- -- Script: rolling_back.sql -- Purpose: to predict when transactions will finish rolling back -- For: 9.0+ -- --…
#POST 2 MIN READ
2007-04-19

EVENT: 10500 "turn on traces for SMON"

Error: ORA 10500 Text: turn on traces for SMON ------------------------------------------------------------------------------- Cause: Action: Level: <=5 trace instance recovery > 5 trace…
#POST 1 MIN READ
2007-01-24

Skip Scanning of Indexes Advantages

What is skip scanning?   In prior releases, a composite index would be used to retrieve the records, if the…
#POST 3 MIN READ
2006-08-04

Know more about DML

The change vectors as constructed by the transaction layer are used by the cache layer to apply the physical block…
#POST 5 MIN READ
2006-07-22

EVENT:10211 check index block integrity

Event:10211                  See <Note:32969.1> for similar events / parameters ~~~~~~~~~~~                     Version/Use:   7.0 - 8.1.7  Check data block integrity after…
#POST 2 MIN READ
2006-07-22

EVENT: 10060 dump predicates in optimizer (kko)

Event:10060 Text:   dump predicates in optimizer (kko) ------------------------------------------------------------------------------- Explanation:         This is a special EVENT code.         It should *NOT*…
#POST 2 MIN READ
2006-07-22

EVENT:10218 dump uba of applied undo

@23-JAN-01, rpowell.uk, Distribution justification: "Should not be used by @ customers unless told to by support so making noncustomer-viewable." -…
#POST 1 MIN READ