Interested to Buy Any Domain ? << Click Here >> for more details...
How will you monitor rollback segment status ?
- 2 Answers
- 5874 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / orawhiz
Querying the DBA_ROLLBACK_SEGS view
IN USE - Rollback Segment is on-line.
AVAILABLE - Rollback Segment available but not on-line.
OFF-LINE - Rollback Segment off-line
INVALID - Rollback Segment Dropped.
NEEDS RECOVERY - Contains data but need recovery or corupted.
PARTLY AVAILABLE - Contains data from an unresolved
transaction involving a distributed database.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / amit bhagat
by using dictionaray view's called v$rollstat,
dba_rollback_segs.
| Is This Answer Correct ? | 0 Yes | 0 No |
How will you swap objects into a different table space for an existing database?
How does Space allocation table place within a block ?
How can we plan storage for very large tables ?
How will you monitor rollback segment status ?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
Which parameter in Storage clause will reduce no. of rows per block?
What do Redo Log Buffers contain?
List the factors that can affect the accuracy of the estimations ?
How to find the current session sid
What is Dedicated Server Configuration?
What are the consideration at tehe migration of Oracle 9i to 10G.
What is the role of PCTFREE parameter is Storage clause ?
Oracle General 
