How can you tell if a tablespace has excessive fragmentation?
No Answer is Posted For this Question
Be the First to Post Answer
What are the five main functions of a database administrator?
Explain force logging feature in 9i.
What is oracle partial backup?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
How can you find your id on a system?
What are the steps involved in instance recovery in oracle?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
What is pct free/pct used/pct increase parameter in segment?
You see a wait on lms process in statspack, what does that mean?
What is main function of database administrator?
When using oracle export/import what character set concerns might come up? How do you handle them?