Monitoring memory usage for each session
You can use some specific onstat -g command arguments to get memory information for each session.
Use the following command arguments to get memory information for each session.
| onstat -g command argument | Description |
|---|---|
| ses | Displays one-line summaries of all active sessions |
| ses session id | Displays session information by session id |
| sql session id | Displays SQL information by session If you omit session id, this argument displays summaries of all sessions. |
| stm session id | Displays amount of memory used by each prepared
SQL statement in a session If you omit session id, this argument displays information for all prepared statements. |
For examples and discussions of session-monitoring command-line utilities, see Monitoring memory usage for each session and Monitor sessions and threads.