Interested to Buy Any Domain ? << Click Here >> for more details...
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
- 0 Answers
- 603 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is oracle dba role?
What skills do you need to be a database administrator?
What is a junior dba?
How do you set up your tablespace on installation level: low?
What is main function of database administrator?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
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?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
What are functions of dba?
Discuss row chaining, how does it happen? How can you reduce it?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
Explain the wait events in statspack report 'enqueue'?
Oracle General 
