Another recent interview question batch, I will provide the answers to these questions whenever I have time. In most cases, you can find the answers in Oracle Performance Tunning Guide

1. You have an Oracle database that hung and you can't login. What will you do to troubleshoot the problem?
2. Which Oracle process will collect the unused temporary tablespace extents?
3. What're the common wait events you see in statspack? And how to deal with them? (Again)

to be continued