Un-Answered Questions { Oracle DBA (Database Administration) }

System tablespace cant be exported from one database and imported into another why?

382


Explain the wait events in statspack report 'db sequential real'?

416


Explain the wait events in statspack report 'db scattered read'?

382


What is your favorite tool for day-to-day oracle operation?

350


What is the difference between truncate and delete? How would a full table scan behave after?

388


What is difference between co-related sub query and nested sub query?

394


What is oracle full backup?

378


What is pga_aggregate_target?

394


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.

438


What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

451


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?

400


Tell me about standby database? What should we watch out for?

382


What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

376


Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

471


What are the steps involved in instance recovery in oracle?

382