1. List of active sessions in the database

2. Current tablespace usage:

3. Find the blocking session details:

4. Monitor TEMP tablespace usage:

5. Find the long running queries:

6. Get os spid from sid:

7. Get sid from os spid:

8. Monitor undo tablespace usage:

9. Get sql_text of an SID:

10. Locks present in the database

11. Find the sessions generating lot of redo:

12. Find the session generating undo data:

13. Find temp usage of the sessions:

14. Monitor rollback transactions:

15. Top queries with high elapsed_time:

— Queries in last 1 hour ( Run from Toad, for proper view)