- Think SQL*Loader - it is much faster than anything you can write in
Pro*C for this same task.
- You might look at how much redo is begin generated.
- Use event 10046 to see what kinds of waits are occuring during the run.
--
Ron Reidy
Oracle DBA
zhanggp wrote:
> i have to insert millions of records into one table a day.
> every record is perhaps 512 bytes.
> i use pro*c 's bulk insert like 'exec sql for :n insert ', and the table has
> a primary index and serveral 'not null' constraints.
> at first it inserts 100 records per seconds and after a day it inserts 30
> records per seconds.
> i dont know how slow it will be after a week!
> Does anyone have the idea how to improve the performance?
> thanks a lot
>
>
Received on Thu Mar 06 2003 - 07:40:20 CST
