Ideally, the entire data dictionary would be cached in memory. This query returns the first 1000 bytes of the SQL statement having the highest number of disk reads per execution. This query is designed to help determine the user generated SQL causing a large number of disk reads per statement execution. This query returns the username associated with the SQL statement having the highest number of disk reads per execution. This query is designed to help determine the user causing a large number of disk reads per statement execution.
Every table requires at least one extent.
Ideally, each table should reside in one extent, but this is sometimes not practical. However, each table should reside in the fewest extents possible. This query returns the largest number of extents used by any data base object, i.e. table or index. The percentage that a request for data resulted in a wait for a free block. The percentage that a SQL statement did not need to be reloaded because it was already in the library cache.