OraFAQ Forum: Performance Tuning » altering rollback segment

Home » RDBMS Server » Performance Tuning » altering rollback segment (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

altering rollback segment [message #308870]

Tue, 25 March 2008 14:38

chriswitt
Messages: 7
Registered: August 2006
Location: jam

Junior Member

My questions are:(i am runing oracle9i)

can i alter,rollback segments that are manage automatically(can i change next_extend, maxium_extend,optimise)?

can i created a new roll back segment and i assing a produre to that rollback segment? considering the database is in auto mode.

thank u

Report message to a moderator

Re: altering rollback segment [message #308871 is a reply to message #308870]

Tue, 25 March 2008 14:42

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No for both questions.
If you use undo tablespace and automatic undo management, you don't manage any more the rollback segments.

Regards
Michel

Report message to a moderator

Re: altering rollback segment [message #308873 is a reply to message #308870]

Tue, 25 March 2008 14:57

chriswitt
Messages: 7
Registered: August 2006
Location: jam

Junior Member

iam getting ora-01555 error when i try to compile the procedure, the procedure also never complete and iam having contension on the segment how do i solve this. any ideas?

Report message to a moderator