Scripts
Compile
Compile invalid objects
Show errors
Show errors of invalid objects
Perform
Show active sessions with their reads
Open cursors
Show open cursors per user/process
View locks
Show locks
Sessions
Show session information
Show indexes
Show indexes for a table
Who am I
Shows user and database for current connetion
Timer
Example procedure for measuring execute time in 1/1000 of a second.
Trace
Show cursors in shared pool with their statistics
|