What is ora-1555 snapshot too old error? Explain in detail?
No Answer is Posted For this Question
Be the First to Post Answer
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?
What is dump destination? What are bdump, cdump and udump?
How many types of dba are there?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
Explain the wait events in statspack report 'db sequential real'?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What is the most common database language that a db administrator needs to know?
What is a database instance?
If you see contention for library caches how you can fix it?
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
How would you find total size of database in os level?