> 文章列表 / Page 260

cursor: mutex * events等待事件 cursor: mutex * events等待事件用于Cursor Parent 和 Cursor stats类型的操作： ‘Cursor: Mutex S’ ， 某个进程以SHRD S mode申请一个Mutex， 而该Mutex要么被其他进程已EXCL X mode所持有，要么其他进程正在更新mutex 上的Ref Count。 相关类型...

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 controlfiles Sharing information (between instances) from the controlfile ...

This event occurs when a server process is updating all copies of the controlfile. Controlfile updates occur in the following situations: A checkpoint is reached The session starts a control file tran...

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. Solutions This is not a ve...

cell smart table scan This is an Exadata wait event typically seen during full table scans that have been offloaded to the storage cells. This event replaces waits on "direct path read" in many cases....

This is an Exadata wait event that occurs when doing a restore via RMAN. Exadata automatically offloads RMAN restore activities to the storage cells. Solutions Offloading the RMAN restore activity to ...

This is an Exadata wait event that occurs when fast full index scans are offloaded to the storage cells. This event is related to cell smart table scan except that the object is an index. This event d...

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. Solutions Offloading the RMAN bac...

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 ...

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...