Hi,
I am using Oracle Enterprise stage to Load table into a Oracle database using the below option
Write Method : Load
Write Mode :Append
I am using the below environment variable
$APT_ORACLE_LOAD_OPTIONS --> OPTIONS(DIRECT=FALSE,PARALLEL=TRUE)
is there a way that i specify the Oracle to Commit all the rows at once.
Thanks
sheema
Oracle Commit frequency
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For DIRECT=TRUE that would be correct. For FALSE it falls back to conventional inserts with commits. And you only get 'all rows at once' by setting the commit interval to a very high number AFAIK. Other options will affect the interval like read size and bind size. You'd really need to have a chat with your DBA to get all of the gory details.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks for the reply.
Do we set the commit row interval using the below 2 environment variables, in this case(I am not sure as this is not Upsert Load Method)
$APT_ORAUPSERT_COMMIT_TIME_INTERVAL
$APT_ORAUPSERT_COMMIT_ROW_INTERVAL
please guide me ,how to set the commit intervals when I am using the Load Method.
$APT_ORACLE_LOAD_OPTIONS --> OPTIONS(DIRECT=FALSE,PARALLEL=TRUE)
Do we set the commit row interval using the below 2 environment variables, in this case(I am not sure as this is not Upsert Load Method)
$APT_ORAUPSERT_COMMIT_TIME_INTERVAL
$APT_ORAUPSERT_COMMIT_ROW_INTERVAL
please guide me ,how to set the commit intervals when I am using the Load Method.
$APT_ORACLE_LOAD_OPTIONS --> OPTIONS(DIRECT=FALSE,PARALLEL=TRUE)
Thanks
Sheema
Sheema