Monitoring Memory Usage for Each Session

Use the following onstat -g arguments to obtain memory information for each session.

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 Monitoring Sessions and Threads.