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
Explain the various modes of normalization?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
Why are recursive relationships bad? How do you resolve them?
Discuss row chaining, how does it happen? How do you correct it?
How to drop an oracle database?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
What is the finger command?
What is ora-1555 snapshot too old error? Explain in detail?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
If you see statistics that deal with "undo" what are they really talking about?
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 exactly does a dba do?