Oracle 8.1.6.3 on Sun Solaris 2.6.
The rollback tablespace filled up last night and the rollback segments
became full. I added space to the tablespace and tried shrinking the
rollback segments. They remained full, so I altered them offline and
online. The extents are increasing, but I still
Terry,
Can you see if there are any session(s) (runaway or not) that might be
causing your rollback segments to fill up? Until you can figure out what
sessions are filling up the rollbacks you will be stuck adding more space
until those session(s) end.
Bryan
-Original Message-
Sent:
Terry,
What do you have optimal set to? I believe shrink only shrinks to the optimal size.
Jim
Ball, Terry [EMAIL PROTECTED] wrote:
Oracle 8.1.6.3 on Sun Solaris 2.6.
The rollback tablespace filled up last night and the rollback segments
became full. I added space to the tablespace and
by: Subject: Rollback segment shrinks
root@fatcity.
com
Title: RE: Rollback segment shrinks
Terry,
This query will tell you which process is using which rollback segment, maybe
that'll help you backtrack to find out what's going on.
column Oracle UserName FORMAT a15
column RBS Name format a15
select r.name RBS Name, p.spid, l.sid ORACLE PID
segment
shrinks
root@fatcity.
com
June 05, 2002
11:53 AM
Please
respond to
ORACLE-L
Oracle 8.1.6.3 on Sun Solaris 2.6.
The rollback tablespace
Title: RE: Rollback segment shrinks
Terry,
This query will tell you which process is using which rollback segment, maybe
that'll help you backtrack to find out what's going on.
column Oracle UserName FORMAT a15
column RBS Name format a15
select r.name RBS Name, p.spid, l.sid ORACLE PID