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 should a dba know?
Explain the wait events in statspack report 'db scattered read'?
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 dump destination? What are bdump, cdump and udump?
How do you install statspack?
What parameters control copy latches?
What are types of data model?
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
What are functions of dba?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
How can you tell if a tablespace has excessive fragmentation?
If you are not sure what command does a particular unix function what is the best way to determine the command?