We have migrated to new Google sites!
Post date: Oct 19, 2014 5:46:32 PM
This report displays the information related to active sessions such as
No of Active Sessions
No of Waiting Sessions
Resources (CPU, MEMORY, DISK READ, DISK WRITE, NETWORK READ, NETWORK WRITE, LOAD ON DCA) consumed by active sessions
Most used resource queue
SWAP used
Query Submit time, Start time and Query Text
Which database user is running most of the queries and what resource queue is being used by those queries
Locks
Idle Sessions
Long running queries
Note: As of today, I have not found this report on Pivotal documents so I thought of creating one for my internal use only.