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: Rollback segment sizing...?

Re: Rollback segment sizing...?

From: Erik <ecotsonas_at_saraswati.com>
Date: Wed, 16 Jun 1999 18:22:47 GMT
Message-ID: <7k8q1a$rr3$1@nnrp1.deja.com>


In article <3767F77A.B5C0593F_at_flash.net>,   Pankaj Asundi <asundi_at_flash.net> wrote:
> We are trying to insert data (about 3500 transactions, each
transaction
> being 450k) into 12 different tables. We have one rbs which is 2 gigs
> and we seem to be running out of space on that rbs.
>
> How do u size rbs based on this transaction?
> Is there a formula/rule of thumb to use?
>
> Any help is appreciated..
>
> PA
>
>

Can you process the transaction so that a commit occurs after each transaction?

Erik
--
Consultant
Saraswati Systems Corporation - (SSC)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 16 1999 - 13:22:47 CDT

Original text of this message

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