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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Huge INSERT and unfriendly ROLLBACK

Re: Huge INSERT and unfriendly ROLLBACK

From: Thor <thor_at_echidna.net>
Date: 1998/11/09
Message-ID: <7280u8$e6s$1@news.bctel.net>#1/1

You don't give much to go on ... but I'd look at what operations I could perform in "unrecoverable" and see if they met my needs.

Thor HW
buzkoff_at_my-dejanews.com wrote in message <727gfa$o4h$1_at_nnrp1.dejanews.com>...
>I'd like to get some opinions from people about a problem already raised in
>this group, though, with a dissatisfying answer.
>
>I run a huge INSERT, approx. 500,000 records. The reason I do it is the
 speed
>of the operation. If I use PL/SQL with commits after each 10,000 records,
 as
>was suggested here, it takes ages.
>
>Now in more than 60% of cases, transactions just hang, doing some "db
>sequential reads" or giving me the "unable to extend rollback segment"
 error.
>My RBS is 140M and if I look at all of the segments they rarely extend 40M.
>
>So what might be the solution?
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Nov 09 1998 - 00:00:00 CST

Original text of this message

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