<< Click to Display Table of Contents >>

Table Scans

Top Previous Next

The page shows the number of

Table scans on long tables (in blue)

Table scans on short tables (in green)

The solid lines show the current snapshots, while the dotted horizontal lines show the database defaults.

This data is taken from the table scans (long tables) and table scans (short tables) rows in V$SYSSTAT.

The value for the large tables should be as low as possible.