If you see the value for reloads is high in the estat library cache report is this a matter for concern?
No Answer is Posted For this Question
Be the First to Post Answer
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
What are functions of dba?
Explain the term 'oracle grid architecture'?
What is an artificial (derived) primary key?
When should the default values for oracle initialization parameters be used as is?
When using oracle export/import what character set concerns might come up? How do you handle them?
How much money does a dba make?
Discuss row chaining, how does it happen?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
What is the use of the drop option in the alter table command?
Explain the various modes of normalization?
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?