Rollback Segment Question

Hi All

 I had a long PL/SQL prg to run .

 I created a special rollback segment for that script with the storage of
(initial 1 m next 1m minextents 2).

 After a few minutes of running I got the "Snapshot too old" error.

 In the v_$rollstat view I got : extents=2, rssize ~ 2 M, hwmsize ~ 2 M.  

I recreated the RBS with minextents 100, at this time my program run succefully.

My question is why in the first case the RBS didn't growth automatically by allocating a new extents until maxetents value ?

Thank you

Best Regards
Kamel Benlatreche

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: GL2Z/ INF  DBA BENLATRECHE
  INET: kbenlatreche_at_lth.sonatrach.dz

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).