Rollback segment space

   Does the space from a rollback segement ever get reclaimed    by Oracle?  

   I'm using Oracle V6.0.36 running on a Sun (OS 4.1.3).

   I have created two rollback segements (rollback_seg1 and    and rollback_seg2) both sit in a 10MB tablespace called    rollback_segs. When I query the sys.dba_free_space table,    summing up the "BYTES" column for the rollback_segs tablespace,    it comes out to around 2MB.

   I can live with this, but it never seems work its way back up    to 10M - even if nobody is using Oracle. I thought when    someone exited or quit oracle, automatic commits were performed    and the space reserved in the rollback segements would be    released.

   My rollback segements have been setup using the following    values.

       Initial extent  40960
       Next extent     40960
       Max extent       9999    <-- My block size is 2048,
                                    so max-extents is really
                                    only 121.
       PCT increase        0    <-- recommended by Oracle.

  

    I can create more rollback segments, but I would like to     know what Oracle is doing with that 8MBs of space it says     is being used.

    Thanks in advance     

    David Hiltz
    NMFS, MA
    dhiltz_at_whsun1.wh.whoi.edu
    #####&_at_&###### Received on Wed Feb 03 1993 - 20:42:41 CET