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?
- 0 Answers
- 558 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between truncate and delete? How would a full table scan behave after?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What do you understand by a control file?
Tell me about standby database? What are some of the configurations of it?
How can I learn oracle dba?
What operator tests column for the absence of data?
Explain force logging feature in 9i.
What does dba stand for database?
What is the difference between a database and instance? What is the relation between them?
What is the meaning of database backup?
What are the five main functions of a database administrator?
What skills do you need to be a database administrator?
Oracle General 
