Commit row interval for OCI stage

parag.s.27 · Post by **parag.s.27** » Thu Oct 18, 2007 2:09 am

I am having more than 30 million records, and when I am inserting in the Oracle table via OCI stage it commits the transactions automatically after 64 records.

I checked in my env variables settings, the

Code: Select all

$APT_ORAUPSERT_COMMIT_ROW_INTERVAL=5000

,

here you can see that commit interval is 5000 but still it commits on 64.

ArndW · Post by **ArndW** » Thu Oct 18, 2007 2:17 am

Oddly enough I have a call open to support for a simliar issue - but in my case the settings for time-based and row-based commits are being ignored but the commit isn't done until the job finishes. What platform are you running on?

parag.s.27 · Post by **parag.s.27** » Sat Oct 20, 2007 5:55 am

ArndW wrote:Oddly enough I have a call open to support for a simliar issue - but in my case the settings for time-based and row-based commits are being ignored but the commit isn't done until the job finishes. What platform are you running on?

Hi,

I am using Oracle 10g and on Unix Box. I even tried and changed the settings of limit to 1000 but the job aborts with SQL loader fatal error. So when I removed the env variable from my job properties, it again atarted commiting on 64 records and worked fine.

Only issue is I am having records more than 30 Million, and it is taking too much time.