Re: Problem with Insertion time
From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Thu, 14 Mar 2002 13:44:37 -0800
Message-ID: <a6r5ip$pjg$1_at_spiney.sierra.com>
Date: Thu, 14 Mar 2002 13:44:37 -0800
Message-ID: <a6r5ip$pjg$1_at_spiney.sierra.com>
The fastest way(s) I know to do inserts are:
- use SQL*Loader with DIRECT=TRUE or
- insert /*+ APPEND */ into a_table NOLOGGING select * from b_table
I use large rollback segment sizees (200M, minextents = 20) and NOARCHIVELOG mode.
Of course, the number of indexes on the destination table severly impacts the insertion rate
"Leader" <sohelcsc_at_yahoo.com> wrote in message
news:b1a93c73.0203130305.58a55806_at_posting.google.com...
> Hi All,
> I am facing problem with insertion in Oracle.
> Insert statement is taking more time. Suppose i want to insert 30,000
> rows at a time within few seconds. Is there any way in Oracle to tune
> the performance of Insertion time??
> Please help!!
> Hoque
Received on Thu Mar 14 2002 - 22:44:37 CET