Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Which type of rollback segment is automatically dropped when it is no longer needed by the Oracle Server?

April 26, 2017automatically dropped longer needed Oracle Rollback segment server type

0

Posted

Which type of rollback segment is automatically dropped when it is no longer needed by the Oracle Server?

1 Answer

0

Posted

The SYSTEM rollback segments record changes made to objects in the SYSTEM tablespace. Private rollback segments are acquired by an instance when they are named in the parameter file. Public rollback segments are in the pool of rollback segments. Deferred rollback segments are created by the Oracle Server when a user attempts to commit a transaction that will change data in a tablespace that is offline. The Oracle Server will drop these segments when they are no longer needed.