Home » RDBMS Server » Server Administration » Rollback Segments (Oracle 10.2.0 on Linux AS4)
Rollback Segments [message #291721] Sun, 06 January 2008 04:21 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

I'm quiet perplexed with the Rollback segments . Can you help me out in dealing with Rollback segments, the modes of RBS and the optimal usage of RBS . Please let me know if there is any article on RBS .

Regards,
Raj
Re: Rollback Segments [message #291722 is a reply to message #291721] Sun, 06 January 2008 04:25 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Whats your oracle version?
WHy worry about rollback segments when we have oracle managed undo tablespaces.
Re: Rollback Segments [message #291724 is a reply to message #291722] Sun, 06 January 2008 04:40 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello,

My Oracle version is Oracle 10g release 2. I know that In 10g we have the UNDO Tablespace. But I want to have what are those RBS and all the different modes of RBS .
And also difference between RBS/UNDO .

Regards,
Raj
Re: Rollback Segments [message #291726 is a reply to message #291724] Sun, 06 January 2008 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The main difference is that you don't to care how to size or handle them all is done by Oracle.
You just have to size your undo tablespace and undo_retention parameter.

Regards
Michel
Re: Rollback Segments [message #291730 is a reply to message #291721] Sun, 06 January 2008 05:28 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Part II Oracle Database Architecture
Chapter 2 Data Blocks, Extents, and Segments
Section Overview of Segments
Subsection Introduction to Automatic Undo Management

This kind of questions are all answered in "Database Concepts"

Regards
Michel
Previous Topic: How do I move this cluster object to another tablespace?
Next Topic: Character set vs National Character set
Goto Forum:
  


Current Time: Tue Dec 06 14:00:24 CST 2016

Total time taken to generate the page: 0.19119 seconds