Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
No Answer is Posted For this Question
Be the First to Post Answer
Why do we need a database?
What do you understand by the term 'system change number (scn)'?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What are the different responsibilities of a dba?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
What are the main benefits of using spfile over pfile?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
What does a senior database administrator do?
What do you mean by oracle dba and what is its role?
How would you find total size of database in os level?
What is dba in sound level?
Which rman command is used to create an exact replica of a database innew host?