Oracle和MySQL - 博客园

cell multiblock physical read等待事件

摘要： This is an Exadata wait event similar to 'db file scattered read' and typically indicates the statement is performing a full table scan or an index fast full scan. This wait event is not seen nearly a... 阅读全文

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

cell single block physical read等待事件

摘要： This is an Exadata wait event similar to db file sequential read and normally occurs during index lookups when the block is not in memory and must be read from the Exadata storage cell disks. These ar... 阅读全文

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

cell smart file creation等待事件

摘要： Sessions wait on this event in Exadata when creating tablespaces, adding files to an existing tablespace or automatic expansion a data file because of DML operations, e.g. data is being loaded into a ... 阅读全文

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

cell smart incremental backup等待事件

摘要： This is an Exadata wait event that occurs when doing incremental level 1 backups via RMAN. Exadata automatically offloads RMAN backup activities to the storage cells.SolutionsOffloading the RMAN backu... 阅读全文

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

cell statistics gather等待事件

摘要： This is an Exadata wait event that occurs when a session is reading information from V$CELL, V$CELL_THREAD_HISTORY and other assocociated views/tables in this same category.SolutionsThis is not a very... 阅读全文

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

control file parallel write等待事件

摘要： This event occurs when a server process is updating all copies of the controlfile.Controlfile updates occur in the following situations:A checkpoint is reachedThe session starts a control file transac... 阅读全文

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

control file sequential read等待事件

摘要： This is a read from a single copy of the control file. This happens in many cases. For example, while:Making a backup of the controlfilesSharing information (between instances) from the controlfileRea... 阅读全文

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

cursor: mutex S等待事件

摘要： A session waits on this event when it is requesting a mutex in shared mode, when another session is currently holding a this mutex in exclusive mode on the same cursor object.SolutionsSolutions for mu... 阅读全文

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

cursor: mutex X等待事件

摘要： A session waits on this event when it has requested a mutex for a cursor object in exclusive mode but must wait because it is busy. The mutex is busy because either the mutex is being held in exclusiv... 阅读全文

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

cursor: pin S等待事件

摘要： A session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of updating a shared mutex pin for the same cursor object. This wait event shou... 阅读全文

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

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