What are the roles and responsibilities of oracle dba?
No Answer is Posted For this Question
Be the First to Post Answer
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
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 skills do you need to be an administrator?
What are elements of administration?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
Explain the various modes of normalization?
Explain the wait events in statspack report 'enqueue'?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What are the five functions of a database?
What do you understand by the term 'system change number (scn)'?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?