top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What are the states of a rollback segment? What is the difference between partly available and needs recovery in Oracle?

+1 vote
833 views
What are the states of a rollback segment? What is the difference between partly available and needs recovery in Oracle?
posted Dec 22, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

The various states of a rollback segment are:
ONLINE, OFFLINE, PARTLY AVAILABLE, NEEDS RECOVERY and INVALID.

answer Dec 23, 2014 by Arun Gowda
Similar Questions
+2 votes
Oracle:If a transaction is very large..will the transaction span across different rollback segments

Below is the one of the interview question which was held by Oracle

If a transaction is very large, and the rollback segment is not able to hold the rollback information, then will the transaction span across different rollback segments or will it terminate?

...