Term
| Prints allocated memory fragments for a specified session or shared-memory pool. To obtain the pool name, see the onstat -g mem option. |
|
Definition
|
|
Term
| Prints free fragments for a session or shared memory pool. |
|
Definition
| onstat -g ffr (pool name session id) |
|
|
Term
| Prints session or pool virtual shared memory statistics. |
|
Definition
|
|
Term
| Prints Memory Grant Manager (parallel and sort operations) resource information. |
|
Definition
|
|
Term
| Prints block map for non-resident segments. |
|
Definition
|
|
Term
| Prints block map for resident segment. |
|
Definition
|
|
Term
| Prints memory segment statistics. |
|
Definition
|
|
Term
| Prints session information, including memory breakdown. |
|
Definition
|
|
Term
| Prints SQL statement memory use. |
|
Definition
|
|
Term
| Prints stream queue buffers. |
|
Definition
|
|
Term
| Prints memory pool fragments for a session or shared memory pool in use. |
|
Definition
|
|
Term
| Prints buffer pool queues and their status. |
|
Definition
|
|
