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