When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
No Answer is Posted For this Question
Be the First to Post Answer
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?
What skills should a dba have?
What degree do database administrators need?
Which files are vital that should be backed up?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
What is a database instance?
Who is dba in dbms?
What os user should be used for the first part of an oracle installation (on unix)?
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 many redo logs should you have and how should they be configured for maximum recoverability?
What does >> do?
What does the no logging option do? Why would we be careful of using it?