What are the steps involved in instance recovery in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Does dba need to know programming?
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?
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
What is different type of rman backup?
What happens if a tablespace clause is left off of a primary key constraint clause?
Tell me about standby database? What should we watch out for?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
How do you use automatic pga memory management with oracle 9i and above?
What are the five main functions of a database administrator?
What does the no logging option do? Why would we be careful of using it?
Why do we need a database?
How much money does a dba make?