How do you install statspack?
No Answer is Posted For this Question
Be the First to Post Answer
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
What is the easiest method to create a file on unix?
What is difference between logical standby database and physical standby database?
What parameters control copy latches?
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.
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
What is the main function of database?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
How do you generate file output from sql?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?