1)When looking at V$SYSSAT, you see that sorts(disk) is high. Is this bad or good? If bad - how do you correct?
2)How do you know a table needed to be reorganized? Index?
3)What are some indications that you need to increase the SHARED_POOL_SIZE parameter?
4)How can you find out how many users are currently logged into the database? How can you find their operating system ID?
5)If a user can not access the database, how do you help him?
6)How to find the SQL statement causing a lock?
7)How can you determine the space left in a file system? (UNIX)?
8)What is “snapshot too old” error? What’s the reason? How to solve the problem?
9)What does this error mean: ORA- 12203: TNS: Unable to connect to destination?
What steps would you take to diagnose and solve this error?
10)If the database crashes, which files do you need to recover it?
11)How do you know a table needed to be reorganized? Index?

Thanks in advance
Jung