Home » RDBMS Server » Server Administration » Diff. between undo & rollback segments??
Diff. between undo & rollback segments?? [message #57851] Fri, 11 July 2003 02:38 Go to next message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Hi all,
Can anyone help me !! My question is what is the difference between undo & rollback segment.

TIA,
Sachin

Report message to a moderator

Re: Diff. between undo & rollback segments?? [message #57852 is a reply to message #57851] Fri, 11 July 2003 03:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
undo segment and rollback segment are one and the same.
in 9i, there is an undo tabblespace and rollback seg.
again both are of same fnctionality.
default is undo tablespace and it is automatically managed by oracle

Report message to a moderator

How this diff. between undo & rollback segments?? [message #57853 is a reply to message #57852] Fri, 11 July 2003 05:00 Go to previous message
jack
Messages: 123
Registered: September 2000
Senior Member
how dba have to tune the raollback segment mannually
even though we r setting parameters for both undo and rollback.SO how its become more easier to dba's undo even undo also we have to do the parameter settings

Report message to a moderator

Previous Topic: Database coneectivity
Next Topic: Create another new instance on Win 2K server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 22 06:23:36 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.