Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
Discuss row chaining, how does it happen? How can you reduce it?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
While taking hot backup (begin end backup) what will happens back end?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
If you are not sure what command does a particular unix function what is the best way to determine the command?
If you see contention for library caches how you can fix it?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
What are some indications that you need to increase the shared_pool_size parameter?
When should you increase copy latches? What parameters control copy latches?
How should a many-to-many relationship be handled?
If you see statistics that deal with "undo" what are they really talking about?