Select Session Statistic

This window enables the changing of the session statistics used by the corresponding columns in the Session Details window. You can select statistics and select whether the cumulative or delta value should be used.

For convenience, there are a few predefined statistics out of all the other standard statistic classes in v$statname:

• File IO - "physical reads"+"physical writes";
• CPU Usage - "CPU used by this session";
• Memory - "session uga memory";
• Open Cursors - "opened cursors current";
• User Transactions - "user commits"+"user rollbacks";

All available statistics are grouped into classes as defined by Oracle in v$statname.CLASS: User, Redo, Enqueue, Cache, OS, Parallel Server (RAC), SQL, Debug (see also Oracle Database Reference).

Please remember there are two Session Statistic columns in the Session Details window, and they can only be changed one at a time.