This is an old revision of the document!

Tuning

Wait-based tuning query

0@@

Identifying I/O Problems Using V$ Views

The V$IOSTAT_FILE view captures I/O statistics of database files that are or have been accessed.<br /> The SMALL_SYNC_READ_LATENCY column displays the latency for single block synchronous reads (in milliseconds), which translates directly to the amount of time that clients need to wait before moving onto the next operation.<br /> This defines the responsiveness of the storage subsystem based on the current load.<br /> If there is a high latency for critical datafiles, you may want to consider relocating these files to improve their service time.<br /> To calculate latency statistics, timed_statistics must be set to TRUE.

1@@

Show sql statements running at specific times (between 2 snapshot id's)

List is taken from ASH/AWR tables

2@@

dbawiki

Table of Contents

Tuning

Wait-based tuning query

Identifying I/O Problems Using V$ Views

Show sql statements running at specific times (between 2 snapshot id's)

References