Discuss row chaining, how does it happen? How do you correct it?
No Answer is Posted For this Question
Be the First to Post Answer
What is an artificial (derived) primary key?
What are some indications that you need to increase the shared_pool_size parameter?
What are database skills?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
As an oracle dba what are the entire unix file you should be familiar with?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
List five most important parameter in 9i affecting performance?
If you see statistics that deal with "undo" what are they really talking about?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
What skills do you need to be an administrator?
How can I learn oracle dba?
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?