Term
| Prints buffer pages in use. |
|
Definition
|
|
Term
| Prints buffer pages that have been touched. |
|
Definition
|
|
Term
| Prints state of buffer queue cleaners and I/O. |
|
Definition
|
|
Term
Prints data dictionary cache, containing system catalog
data for tables. Prints one line of information for each table cached in the shared-memory dictionary. |
|
Definition
|
|
Term
| Prints table distribution statistics for the optimizer. |
|
Definition
|
|
Term
| Prints the stored procedure (SPL) routine cache. Prints information about SPL routine cache |
|
Definition
|
|
Term
| Prints the number of times that the database server reads the SQL statement in the cache. Displays the same output as onstat -g cac. |
|
Definition
|
|
Term
| Prints CPU virtual processor memory cache. |
|
Definition
|
|
Term
| Prints buffer hash chain information. |
|
Definition
|
|
Term
| Prints optical subsystem memory cache and staging-area (disk cache) blobspace for TEXT or BYTE data. |
|
Definition
|
|
Term
| Prints global (server) information regarding the effectiveness of buffer pool caching. |
|
Definition
|
|
Term
| Prints threads waiting on buffers. |
|
Definition
|
|
