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 is the full form of dba?
How can you find your id on a system?
How would you find total size of database in os level?
What is the easiest method to create a file on unix?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
If you see statistics that deal with "undo" what are they really talking about?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What is a dba programmer?
You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
List five most important parameter in 9i affecting performance?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
If you see contention for library caches how you can fix it?