Re: Estimating rollback segment size

From: BS <minimyme_at_yahoo.com>
Date: 24 Aug 2006 09:29:42 -0700
Message-ID: <1156436982.130122.274740@i42g2000cwa.googlegroups.com>

> Hi,
>
> Are you sure you don't have other transactions running? 46K rows that
> will have ~350MB (at most) updated shouldn't generate that much undo.
>
> I assume you are on 8i since you are using rollback segments. You can
> check v$transaction, as since at least that release, it has columns for
> the number of blocks a transaction is using.
>
> http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch3175.htm#11192
>
> Regards,
>
> Steve

I have only one transaction as thisis in a test system. What will be the relation between the # of blocks and MB's being used? Received on Thu Aug 24 2006 - 11:29:42 CDT