onstat -g dic command: Print table information
Use the onstat -g dic command to display a line of information about each table that is cached in the shared-memory dictionary. If you specify a table name, this command prints internal SQL information about that particular table.
Syntax:
onstat -gdicExample output
Output description
- list#
- Data dictionary hash chain ID
- size
- Number of entries in this hash
- refcnt
- Number of SQL statements currently referencing one of the cache entries.
- dirty?
- Whether the entry has been modified since last written to disk.
- heapptr
- Address for the heap used to store this table
- table name
- Name of table in cache