From: alice@reply-to-group.com   
      
   Thank Matt.   
      
   Regards,   
   Alice   
      
   "Matt"  wrote in message   
   news:cfee5bcf.0404080123.64767013@posting.google.com...   
   > No.  A transaction will only use as much space as it requires.   
   >   
   > The rollback segment tablespace is just like any other tablespace (as   
   > far as storage is concerned).  Therefore it will allocate storage in   
   > multiples of database blocks (db_block_size).   
   >   
   > A rollback segment that has 20 extents of 5Mb each has 100Mb available   
   > for use by any number of transactions concurrently.   
   >   
   > Matt   
   >   
   >   
   >   
   > "Alice"  wrote in message   
   news:<40742a46_1@news.tm.net.my>...   
   > > Hi all,   
   > >   
   > > Given a rollback segment with storage as follows :   
   > > Initial Extent 5 MB   
   > > Next Extent 5 MB   
   > > Min Extents 20   
   > >   
   > > Does this mean that every time a transaction uses this rollback segment   
   it   
   > > allocates 100 MB ?   
   > > Does this mean that if there are two transactions using this rollback   
   > > segment, 200 MB is required ?   
   > >   
   > > Thanks,   
   > > Alice   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)