The onstat -O option

The onstat -O option displays information about the staging-area blobspace and the Optical Subsystem memory cache. The totals shown in the display accumulate from session to session. The database server resets the totals to 0 only when you run onstat -z.

For an example of onstat -O output, see information about the onstat utility in the HCL OneDB™ Administrator's Reference.

The first section of the display describes the following system-cache totals information.

Column: Description
size: Size specified in the OPCACHEMAX configuration parameter
alloc: Number of 1 KB pieces that the database server allocated to the cache
avail: Portion of alloc (in KB) not used
number: Number of simple large objects that the database server successfully put into the cache without overflowing
kbytes: Number of KB of the simple large objects that the database server put into the cache without overflowing
number: Number of simple large objects that the database server wrote to the staging-area blobspace
kbytes: Number of KB of simple large objects that the database server wrote to the staging-area blobspace

Although the size output indicates the amount of memory that is specified in the configuration parameter OPCACHEMAX, the database server does not allocate memory to OPCACHEMAX until necessary. Therefore, the alloc output reflects only the number of 1 KB pieces of the largest simple large object that has been processed. When the values in the alloc and avail output are equal, the cache is empty.

The second section of the display describes the following user-cache totals information.

Column: Description
SID: Session ID for the user
user: User ID of the client
size: Size specified in the IONEDB_ OPCACHE environment variable, if set
If you do not set the IONEDB_ OPCACHE environment variable, the database server uses the size that you specify in the configuration parameter OPCACHEMAX.
number: Number of simple large objects that the database server put into cache without overflowing
kbytes: Number of KB of simple large objects that the database server put into the cache without overflowing
number: Number of simple large objects that the database server wrote to the staging-area blobspace
kbytes: Size of the simple large objects (in KB) that the database server wrote to the staging-area blobspace