> 文章列表 / Page 260

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

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