top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

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

+1 vote
316 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

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?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...