How to insert data fast

From: Takaoki Sekiguchi <takaoki_at_cow.melco.co.jp>
Date: Thu, 14 Jul 1994 18:26:31 GMT
Message-ID: <TAKAOKI.94Jul14132631_at_visar.cow.melco.co.jp>


I am going to insert 2GB data into oracle database. But it took about 1 hour to insert 40MB data.!!

The situation is as follows.

 1 Data is created by program and sent to oracle by oci functions.  2 Data is stored in array(size 100) and sent by 'oexn' function.  3 Commit is made for each oexn.
 4
 4 It is impossible to use The direct path for SQL*Loader ,

    because table are made on hashed cluster.    It is invalid to use the direct path SQLload for hashed cluster.  5 SQL*Loader using normal path is slower than the oci program.

I have some questions.
Please send mail to takaoki_at_ok.cow.melco.co.jp   ,if it's not inconvinient for you.    

Q1,Are there way to tuen Redo Log off?

   If someone knows it, Please tell me.
   If Redo Log turned off,data insert would be much faster,wouldn't it? Q2,What parameters do I have to change in order to fast data insert ?

    and to What values do I set those parameters? Q3,

Thanks in advance.

--

**************************************************
三菱電機(株) 情報システム製作所 高性能サーバ開発部 開発第3グループ 関口 孝興 E-mail: takaoki_at_ok.cow.melco.co.jp 〒251 神奈川県鎌倉市上町屋325番地 TEL 0467-43-8301 FAX 0467-43-8272 MIND 7-421-8548
**************************************************
Received on Thu Jul 14 1994 - 20:26:31 CEST

Original text of this message