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?
No Answer is Posted For this Question
Be the First to Post Answer
How do you set up your tablespace on installation level: low?
What is the difference between truncate and delete? Why is one faster?
What file will give you oracle instance status information? Where is it located?
What kinds of responsibilities does a dba have in a database environment?
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
What is main function of database administrator?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
What do you mean by oracle database?
Explain the wait events in statspack report 'db sequential real'?
What is the purpose of the grep command?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
What are the different responsibilities of a dba?