Monitoring memory usage for each session

You can use several onstat -g command options to obtain memory information for each session.

To identify SQL statements using large amount of memory:

1. Run the onstat -g ses command to display memory of all sessions and see which session has the highest memory usage.
2. Run the onstat -g ses session-id command to display more details on the session with the highest memory usage.
3. Run the onstat -g stm session-id command to display the memory used by the SQL statements.