What is the transaction size and array size in OCI stage?how these can be used?

Showing Answers 1 - 1 of 1 Answers

laxman

  • Jul 24th, 2006
 

Transaction Size - This field exists for backward compatibility, but it is ignored for release 3.0 and later of the Plug-in. The transaction size for new jobs is now handled by Rows per transaction on the Transaction Handling tab on the Input page.

Rows per transaction - The number of rows written before a commit is executed for the transaction. The default value is 0, that is, all the rows are written before being committed to the data table. 

Array Size - The number of rows written to or read from the database at a time. The default value is 1, that is, each row is written in a separate statement.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions