Monday, August 31, 2015

db file scattered read, db file sequential read & direct read wait events explanation

›
As Oracle DBA's we come across these wait events in most environments. We will discuss their definitions and see what we can do to reduc...
Saturday, February 14, 2015

Analyzing & Interpreting AWR Report

›
Analyzing and Interpreting AWR from pasalapudi
Friday, January 3, 2014

Top 5 Timed Foreground Events - Streams miscellaneous event

›
Streams miscellaneous event The Streams miscellaneous event will be renamed to "Waiting for additional work from the logfile" t...
Tuesday, December 31, 2013

Exadata Wait Event - Cell Statistics Gather

›
cell statistics gather This wait event appears when a select is done on the V$CELL_STATE , V$CELL_THREAD_HISTORY , or V$CELL_REQUEST_TO...

Exadata Wait Event - Cell Smart Table Scan

›
cell smart table scan This wait event appears when the database is waiting for table scans to complete on a cell. The cell hash number ...

Exadata Wait Event - Cell Smart Restore from Backup

›
cell smart restore from backup This wait event appears when the database is waiting for the completion of a file initialization for res...

Exadata Wait Event - Cell Smart Index Scan

›
cell smart index scan This wait event appears when the database is waiting for index or index-organized table (IOT) fast full scans. Th...

Exadata Wait Event - Cell Smart Incremental Backup

›
cell smart incremental backup This wait event appears when the database is waiting for the completion of an incremental backup on a c...

Exadata Wait Event - Cell Smart File Creation

›
cell smart file creation This wait event appears when the database is waiting for the completion of a file creation on a cell. The cell ...