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?
No Answer is Posted For this Question
Be the First to Post Answer
How do you prevent output from coming to the screen?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
When configuring sqlnet on the server what files must be set up?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
What do you mean by oracle dba?
If you see contention for library caches how you can fix it?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
How should a many-to-many relationship be handled?
How can you tell if a tablespace has excessive fragmentation?