Oracle和MySQL - 博客园

EVENT: 10060 dump predicates in optimizer (kko)

摘要： Event:10060Text: dump predicates in optimizer (kko)-------------------------------------------------------------------------------Explanation: This is a special EVENT code. It should *... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(244) 评论(0) 推荐(0) 编辑

EVENT:10211 check index block integrity

摘要： Event:10211 See for similar events / parameters~~~~~~~~~~~ Version/Use: 7.0 - 8.1.7 Check data block integrity after each modification 9.0+ This event i... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(162) 评论(0) 推荐(0) 编辑

Know more about DML

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(126) 评论(0) 推荐(0) 编辑

EVENT:10052 "Stop SMON from cleaning up obj$"

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(145) 评论(0) 推荐(0) 编辑

EVENT 10051:"trace OPI calls"

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(124) 评论(0) 推荐(0) 编辑

EVENT 10235:"check memory manager internal structures"

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(106) 评论(0) 推荐(0) 编辑

VIEW:X$KCCRS-Controlfile Record Section directory (8.0 - 8.1)

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(155) 评论(0) 推荐(0) 编辑

Skip Scanning of Indexes Advantages

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

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(144) 评论(0) 推荐(0) 编辑

Script to Detect Tablespace Fragmentation

摘要： create table SPACE_TEMP ( TABLESPACE_NAME CHAR(30), CONTIGUOUS_BYTES NUMBER)/declare cursor query is select * from dba_free_space order by tablespace_name, bloc... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(218) 评论(0) 推荐(0) 编辑

Network Interface No Longer Operational?

摘要： Solaris平台上的Oracle数据库，Alert日志偶尔会出现"Network Interface No Longer Operational"的相关记录：ospid 11223: network interface with IP address 192.4.1.22 no longer operationalrequested interface 192.4.1.22 ioctl get ... 阅读全文

posted @ 2013-03-19 00:32 Oracle和MySQL 阅读(100) 评论(0) 推荐(0) 编辑

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