Discuss row chaining, how does it happen? How can you reduce it?
No Answer is Posted For this Question
Be the First to Post Answer
What is dba software?
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?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
How many types of database software are there?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
How many control files should you have?
What is difference between logical standby database and physical standby database?
What is an artificial (derived) primary key?
Discuss row chaining, how does it happen? How do you correct it?
What is the finger command?
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?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?