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.


Copyright© 2019 HCL Technologies Limited