Hi,
Can anyone tell me if the commit intervals can be specified in the oracle enterprise stage in Enterprise edition as we do in the OCI stage in Server jobs...??Will the environmental variables will work fine for this issue..??
And...will this commit intervals applies to any RDBMS database like DB2...
Thanks and Regards!!!
Satya Srikanth.. :lol:
Commit Intervals
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Tue May 24, 2005 9:00 pm
- Location: Mumbai
On DB2, we set APT_RDBMS_COMMIT_ROWS to some product of 1024 (usually 8192 or 16384).
Cased on other posting, it looks like Oracle may not be able to do this, but I don't know for sure (we only use DB2 and Teradata). You should search the site for more info, but here are some related topics:
1) viewtopic.php?t=93065&highlight=aptrdbmscommitrows
2) viewtopic.php?t=92638&highlight=aptrdbmscommitrows
3) viewtopic.php?t=116&highlight=aptrdbmscommitrows
Cased on other posting, it looks like Oracle may not be able to do this, but I don't know for sure (we only use DB2 and Teradata). You should search the site for more info, but here are some related topics:
1) viewtopic.php?t=93065&highlight=aptrdbmscommitrows
2) viewtopic.php?t=92638&highlight=aptrdbmscommitrows
3) viewtopic.php?t=116&highlight=aptrdbmscommitrows