FOLKs,
I have problem in identifying the commit command in ORA, I have million records comming in I want to commit after every 50,000 records, I was of the opinion rows per transaction under transaction handler is one which takecare of this, I had selected readcommit option but I want commit after every 50,000 records, SQL is user defined, could some one help on this
thanks
ranga
Commmit in ORA
Moderators: chulett, rschirm, roy
Commmit in ORA
RRCHINTALA
I was doing the production support, and I was asked to change commit level from 50000 to 20000, I was told the programs are set up to have commit after 50000.
but to my serprise rows per transaction is set 0, I was wondering where this 50000 is which I have to chane to 20000, and for moment I got doubt on my skills and wanted to make sure, thanks
ranga
but to my serprise rows per transaction is set 0, I was wondering where this 50000 is which I have to chane to 20000, and for moment I got doubt on my skills and wanted to make sure, thanks
ranga
RRCHINTALA