Interested to Buy Any Domain ? << Click Here >> for more details...
What is main function of database administrator?
- 0 Answers
- 560 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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 find out how many users are currently logged into the database? How can you find their operating system id?
What is da in database?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
List five most important parameter in 9i affecting performance?
What is oracle archived redo log?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
If you have an example table, what is the best way to get sizing data for the production table implementation?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
What does database administrator do?
Oracle General 
