Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Performance Monitoring and the Tools You Use > Monitoring Sessions and Queries >

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.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]