How do you prevent oracle from giving you informational messages during and after a sql statement execution?
No Answer is Posted For this Question
Be the First to Post Answer
What are functions of dba?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
Which files are vital that should be backed up?
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?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
When should you increase copy latches? What parameters control copy latches?
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?
How can be determining the size of the log files?
What is main function of database administrator?
What are the important tasks of common oracle dba?
Why are recursive relationships bad? How do you resolve them?