Re: bulk insert - to make it faster

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 27 Mar 2006 20:38:29 +0200
Message-ID: <s3cg22tqpb2qlp40jqbae3rmgqu7f49p1v@4ax.com>

On 27 Mar 2006 10:04:30 -0800, "picksdba" <Utpal.Dhar_at_gmail.com> wrote:

>I have to insert 32 million records and i have pasted the script below
>that i am using. It is taking a considerable amount of time and wanted
>to know if there was a way to make it faster.

Define 'faster'

Did you set _fast = true in init.ora?

Without joking the code you posted is correct, so there are likely other factors at play. You'll need to find out, from the session statistics, or by tracing it, what this code is waiting for and fix it.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Mar 27 2006 - 12:38:29 CST