What is the maximum buffer value?
Posted: Mon Dec 02, 2013 12:49 pm
Hi- I have a simple job to load data from tables in one database to tables in other database.
The same job is parameterized and will run 20 times to load data which ranges from 1M - 10M
Oracle Connector-> Transformer -> Oracle Connector(Bulk Load)
I am achieving speed of 5000 rec/sec by designing the job with below properties.
4 node config file is being used.
Oracle connector properties (Source) :
Partition Reads method- Rowid Hash
Record Count- 1000000
Array Size - 500000
Maximum memory Buffer Size - 20971520
Buffer free run(percent) - 100
Queue upper bound size - 20971520
Dis write Increments - 13981000
To increase the speed of the job can I still increase the limits?
Are the above limits too much?
Does the buffer size utilize Scratch disk?
If I run similar jobs in parallel will it occupy my scratch disk and jobs will fail?
The same job is parameterized and will run 20 times to load data which ranges from 1M - 10M
Oracle Connector-> Transformer -> Oracle Connector(Bulk Load)
I am achieving speed of 5000 rec/sec by designing the job with below properties.
4 node config file is being used.
Oracle connector properties (Source) :
Partition Reads method- Rowid Hash
Record Count- 1000000
Array Size - 500000
Maximum memory Buffer Size - 20971520
Buffer free run(percent) - 100
Queue upper bound size - 20971520
Dis write Increments - 13981000
To increase the speed of the job can I still increase the limits?
Are the above limits too much?
Does the buffer size utilize Scratch disk?
If I run similar jobs in parallel will it occupy my scratch disk and jobs will fail?