How to insert data fast

From: Takaoki Sekiguchi <takaoki_at_cow.melco.co.jp>
Date: Thu, 14 Jul 1994 19:34:04 GMT
Message-ID: <TAKAOKI.94Jul14143404_at_visar.cow.melco.co.jp>


I have some questions about the way to insert data fast.

I am going to insert 2GB data into oracle database. But it took about 50 minutes 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' by 'ocom'  4 SQL*Loader using normal path is slower than the oci program.  5 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.

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 any way to turn Redo Log off?

    Or are there any setting for 'fast data insert mode'?

   If someone knows about those topics, Please tell me.

Q2,What parameters do I have to change in order to fast data insert ?

    and to What values do I set those parameters?

Q3,What should I do to speed up data insert other than Q1,Q2 ?

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 - 21:34:04 CEST

Original text of this message