Monitoring memory usage for each session

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

You obtain memory information by identifying the SQL statements that use a large amount of memory.

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.

Copyright© 2020 HCL Technologies Limited