What are the steps involved in instance recovery in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
What does a senior database administrator do?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
How can you find dead processes?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
What is explain plan and how is it used?
How do you prevent output from coming to the screen?
What does a dba stand for?
What is oracle full backup?