How can you tell if a tablespace has excessive fragmentation?
No Answer is Posted For this Question
Be the First to Post Answer
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 tkprof and how is it used?
What do you understand by the term 'system change number (scn)'?
Discuss row chaining, how does it happen? How can you reduce it?
What are the types of schemas?
What is the difference between rman and a traditional hotbackup?
How can you determine if an oracle instance is up from the operating system level?
List five most important parameter in 9i affecting performance?
How do I become a dba?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
How do you set up your tablespace on installation level: low?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?