| rollback segments [message #62752] |
Wed, 11 August 2004 12:18  |
jimbob
Messages: 20
Registered: April 2004
|
Junior Member |
|
|
I was poking around my database init.ora file and notice that the rollback_segments line has been commented out...doesn't this indicate that when the database is restarted that I will have to manually bring these segment online?
TIA
jb
|
|
|
|
| Re: rollback segments [message #62756 is a reply to message #62752] |
Wed, 11 August 2004 20:34  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Which version of oracle you are using in 9i there is a new feature called automatic undo management in which all the rollback related tasks as accomplished by oracle itself and there is no need of rollback_segments parameter in init.ora. If you are using oracle 9i, check parameter undo_management in you init.ora to find whether you are using automatic undo management or not.
Daljit Singh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
