On Array Size!!
Posted: Wed Mar 15, 2006 3:35 pm
I was going thru' some previous postings on analyzing your input data and posting trial values for Array Size and Rows per Transaction before achieving an optimal performance while using OCI9. I came across a posting by Ray-
Cheers,
gateleys
So, why was the incomplete array discarded? Don't tell me that the array size should be a factor of Rows per Transaction!!!ray.wurlod wrote:I just had a report from a customer as follows. Job design isThere are 34756 rows to move. Array size is set to 1000. The job loaded 34000 rows, and apparently discarded the incomplete array.Code: Select all
OCI9 -----> HashedFile
Further investigation is required.
Cheers,
gateleys