how to set commit frequency in target Oracle table
Posted: Tue Feb 17, 2004 4:29 pm
Guys,
I need to be able to set the commit frequency on the target Oracle Enterprise stage to be able to avoid problems with rollback segments. would like suggestions from anyone who has done that before. I know there was a Transaction Handling feature in server jobs that enabled us to specify 'rows per transaction' and 'array size' and stuff like that. I dont see such things in parallel jobs. Any ideas how to control the commit frequency?
any help will be appreciated.
I need to be able to set the commit frequency on the target Oracle Enterprise stage to be able to avoid problems with rollback segments. would like suggestions from anyone who has done that before. I know there was a Transaction Handling feature in server jobs that enabled us to specify 'rows per transaction' and 'array size' and stuff like that. I dont see such things in parallel jobs. Any ideas how to control the commit frequency?
any help will be appreciated.