Rows PerTransaction option

arshi · Post by **arshi** » Mon Jul 14, 2008 1:34 am

Hi,

What number we need to put in OCI stage under Transaction Handling- Row Per Transaction Option.

At present we put zero as Row Per Transaction.We can put any number or is there any process for this.

Any one have an idea please suggest me on this.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 14, 2008 2:17 am

Read the Help when you are in this screen. This property governs how often you want to send COMMIT commands to the database server. A value of 0 means not to send a COMMIT until all rows have been sent - this is the safest for recovery, but can mean that the database server may need to handle large transaction sizes.

chulett · Post by **chulett** » Mon Jul 14, 2008 7:13 am

'Any number' up to 99999, from what I recall. If you still are unclear on the concept, have a chat with your friendly neighborhood DBA.