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

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

摘要： This is an Exadata wait event that occurs when doing a restore via RMAN. Exadata automatically offloads RMAN restore activities to the storage cells.SolutionsOffloading the RMAN restore activity to th... 阅读全文

摘要： cell smart table scanThis 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. ... 阅读全文

摘要： Wait occurs when a session attempts to access a block in memory, is denied and must wait until the buffer becomes available. This event happens because a buffer is either being read into the buffer ca... 阅读全文

摘要： This latch is needed when user processes try to scan the LRU (least recently used) chain containing blocks in the buffer cache. This latch must be acquired before the block can be inserted into (when ... 阅读全文

摘要： BackgroundA user process acquires this latch to scan the SGA for database cache buffers. Blocks in the buffer cache are placed on linked lists (cache buffer chains). Blocks are put on the hash chain a... 阅读全文

摘要： This is an Exadata wait event similar to 'db file parallel read' and normally occurs during multi-block reads of non-contiguous blocks. The most common operations associated with this wait event are i... 阅读全文

摘要： Waits on 'db file sequential read' normally occur during index lookups when the block is not in memory and must be read from disk. They are generally considered a 'good' read unless the index being us... 阅读全文

摘要： Sometimes related to sorting operations, check to see if occurring primarily in temp tablespaces. During Direct Path operations the data is asynchronously read from the database files. At some point t... 阅读全文