Home » RDBMS Server » Server Administration » increase Rollback segment on oracle 7.3.3
increase Rollback segment on oracle 7.3.3 [message #405792] Fri, 29 May 2009 08:15 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

I have an oracle 7 on my AIX box. I want to increase the size of the rollback segment.

SEGMENT_NAME
--------------------------------------------------------------------------------
SEGMENT_TYPE MAX(EXTENT_ID) SUM(BYTES)
-------------------- -------------- ----------
R01
ROLLBACK 33 45629440

R02
ROLLBACK 26 38174720

R03
ROLLBACK 26 38174720


SEGMENT_NAME
--------------------------------------------------------------------------------
SEGMENT_TYPE MAX(EXTENT_ID) SUM(BYTES)
-------------------- -------------- ----------
R04
ROLLBACK 25 37109760

Do i need to delete the rollback and then recreate it or can i increase the size.


Thanks,

Sailesh

Re: increase Rollback segment on oracle 7.3.3 [message #405793 is a reply to message #405792] Fri, 29 May 2009 08:19 Go to previous message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
>Do i need to delete the rollback and then recreate it or can i increase the size.
You need to make bigger new ones & then delete old one.
V7.3 has not been supported this century.
You are past due to upgrade.
Previous Topic: No more data to read from socket
Next Topic: error at installation of Oracle 10 Rel 2 on Windows Vista 64x
Goto Forum:
  


Current Time: Fri Dec 09 12:01:02 CST 2016

Total time taken to generate the page: 0.12913 seconds