Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question on Rollback Segment

Re: Question on Rollback Segment

From: <manager43_at_my-deja.com>
Date: Tue, 22 Jun 1999 06:44:23 GMT
Message-ID: <7knbc6$of$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US