Re: How to insert data fast

Takaoki Sekiguchi (takaoki_at_cow.melco.co.jp) wrote:
: 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.

Yes, you can turn off redo logging in V7 - I cant remember the init.ora parameter, take a look at x$ksppi, it has all the undocumented init.ora params you can play with. Received on Wed Jul 20 1994 - 13:45:39 CEST