Oracle和MySQL - 博客园

Know More About Libarary Cache and Latches

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

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

ORA-4031 Common Analysis/Diagnostic Scripts

摘要： 4031_diag_script.zip1. SGA中的内存池包含不同大小的内存块。当数据库启动时，就有一个大的内存块分配并被hush buckets 里的空闲列表追踪。随着时间推移，随着内存的分配和释放，内存块被按照大小在不同的hush buckets间移动。当SGA里任何一个内存池里出现不能满足内部分配请求的情况时，ORA-04031就出现了。shared pool共享池的管理方式不同于其它的... 阅读全文

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

Script:To Report Information on Indexes

摘要： Reports index fragmentation statistics:==========Script #1:==========SET ECHO offREM NAME: TFSIFRAG.SQLREM USAGE:"@path/tfsifrag schema_name index_name"REM ------------------------------------------... 阅读全文

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

Know more about Buffer Cache and Latch

摘要： We can examine X$BH table to obtain buffer header information,The BH stands for buffer header.Structures that maintain a list of data buffer headers are called:Hash buckets.Hash buckets are grouped by... 阅读全文

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

Know more about Oracle Latches

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

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

EVENT:10061 disable SMON from cleaning temp segment

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

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

EVENT:10226 trace CR applications of undo for data

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

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

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." - dbither.usEvent: 10218Text: dump uba of applied undo... 阅读全文

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

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 阅读(262) 评论(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 阅读(173) 评论(0) 推荐(0)

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