Home » Other » Client Tools » Re: rollback segment
Re: rollback segment [message #38677] Mon, 06 May 2002 03:11 Go to next message
mousie
Messages: 9
Registered: March 2002
Junior Member
Thanks Suresh;

That exactly what I do ; before the load I tell Oracle to use the rollback segment called rbs_batch (initial 200 MB, next 10 MB); but there's no more left space in rbs tablespace (this one is always used by 99,95 % even where there is no transaction). So I wonder why the free space doesn't grow when there is no operations or transactions; normally when a commit or rollback is done, the occupied rollback segments are released ; it's not the case here ?

Have you any idea about it ? Thank you very much for your answers.
Re: rollback segment [message #38681 is a reply to message #38677] Mon, 06 May 2002 05:05 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
I think u r looking at allocated space for roll back segment.That doesnt mean your RBS is currently being used by some transactions. Rollback segment grows upto maxextents storage parameter which was set during creation and deallocates to optimal value when you set optimal parameter. join v$transactions, v$session, v$rollname views to get actual info .

query:

select a.username, b.USED_UBLK , c.Name
from v$session a, v$transaction b, v$rollname c
where a.saddr = b.ses_addr and b.xidusn = c.usn ;

HTH
Suresh
Previous Topic: Re: rollback segment
Next Topic: Proc. called automatically from dB
Goto Forum:
  


Current Time: Thu Mar 28 05:24:39 CDT 2024