home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,248 of 2,288   
   Alice to Matt   
   Re: Rollback usage query   
   08 Apr 04 22:19:35   
   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca