The onstat -g cac command displays the status of the in-memory caches. The command may take one or two arguments: the cache name and optionally the entry name within the cache.
Option | Description |
---|---|
agg | Prints information about the aggregate cache. |
aqt | Prints information about the AQT dictionary cache. Prints the same output as the onstat -g aqt command. |
am | Prints information about the access method cache. To see information for a specific access method, include the access method name. |
cast | Prints information about the cast cache. |
dic | Prints information about the data dictionary cache. Prints the same output as the onstat -g dic command. |
dsc | Prints information about the data distribution cache. Prints the same output as the onstat -g dsc command. |
ed | Prints information about the external directives cache. |
lbacplcy | Prints information about the LBAC security policy information cache. |
lbacusrc | Prints information about the LBAC credential memory cache. |
opci | Prints information about the operator class instance cache. |
prc | Prints information about the UDR cache. Prints the same output as the onstat -g prc command. |
prn | Prints information about the procedure name cache. |
rr | Prints information about the routine resolution cache. |
ssc | Prints information about the SQL statement cache. Prints the same output as the onstat -g ssc command. |
ttype | Prints information about the secondary transient cache. |
typei | Prints information about the extended type by ID cache. To see information for a specific extended type, include the extended type ID. |
typen | Prints information about the extended type by name cache. To see information for a specific extended type, include the extended type name. |
The example below is from onstat -g cac ed, most of the options have a similar format and detail the same information
External Directive Cache: Number of lists : 67 list# refcount dirty? hashcode_t database name Hashcodes ----------------------------------------------------------------------------- 30 0 no 0 sysmaster 46 0 no 0 oninit 48 0 no 0 dbaudit 60 0 no 0 wbe 61 0 no 0 dictionary
Field | Description |
---|---|
Number of lists | Number of lists in the distribution cache |
configuration parameter name | Number of entries that can be cached at one time |
list | Distribution cache hash chain ID |
id | The unique ID assigned to the cache entry |
ref | Number of statements that reference a cache entry |
drop | Whether this entry was dropped after it was added to the cache |
hits | The number of times the cache entry is accessed |
heap_ptr | Heap address that is used to store this entry |
item name | The name of the item in the cache |
Total number of entries | Number of entries in the cache |
Number of entries in use | Number of entries that are being used |
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.