If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by oracle database?
What are the different types of database users?
What are the possible ways to gain information regarding the control file?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
What file will give you oracle instance status information? Where is it located?
Which process writes data from data files to database buffer cache?
How can I learn oracle dba?
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
What are the various ingredients of sga?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
What are the main benefits of using spfile over pfile?
Why are recursive relationships bad? How do you resolve them?