You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
No Answer is Posted For this Question
Be the First to Post Answer
How can you determine the space left in a file system?
What is pct free/pct used/pct increase parameter in segment?
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
Explain the wait events in statspack report 'db scattered read'?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
How do I become a database administrator?
What is explain plan and how is it used?
How do you set up your tablespace on installation level: low?
What are types of data model?
What is the relation between database and instance?
What are the steps involved in instance recovery in oracle?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?