Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question on Rollback Segment
Hi,
Pls note that the quantity of segments depend from size of dababase block, for example, is DB = 2KB - 121, etc.
Vladimir
In article <MPG.11d881727cf7f620989692_at_news.singnet.com.sg>,
wanni_at_mbox2.singnet.com.sg (Wanni) wrote:
> Hi Readers,
>
> I have a puzzling question on how the rollback segment allocates its'
> next extent.
>
> We are doing a snapshot refresh, in server A from a master table in
> server B. The size of the master table is 600M. And we have
allocated
> 2G of diskspace for the rollback segment in server A.
>
> Nevertheless, we have server A giving the error "Unable to allocated
next
> extent ...... "
>
> Then we tried to increased the rollback tablespace in server A to 3GB.
> Ok fine, the first 600M table got through. But when we are running
> refresh for another large table, looks like the transaction does not
use
> the extent released by the first transaction (or has it been released
at
> all). instead... it continue to allocate the next extent... and on
and
> on.
>
> Quesiton is - how does rollback segment allocates and deallocated
> extents?
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jun 22 1999 - 01:44:23 CDT