Page 1 of 1
How to increase the number of nodes in Parallel Job
Posted: Fri Mar 28, 2008 5:02 am
by ashishpascal
The Job is reading data from Oracle Database in a parallel Job and its speed is 600 rows per second.
Can anyone tell me as to should i increase the number of records read per minute.
and how should i increase the number of nodes in parallel Job.
Thanks
Ashish Gupta
+919922892057
Posted: Fri Mar 28, 2008 5:10 am
by ray.wurlod
1. Set the system clock back while the job is running.
2. Use a different parallel configuration file. Set APT_CONFIG_FILE to point to it.
Re: How to increase the number of nodes in Parallel Job
Posted: Sun Mar 30, 2008 5:49 pm
by Yuan_Edward
ashishpascal wrote:The Job is reading data from Oracle Database in a parallel Job and its speed is 600 rows per second.
Can anyone tell me as to should i increase the number of records read per minute.
and how should i increase the number of nodes in parallel Job.
Thanks
Ashish Gupta
+919922892057
I observed that Oracle Enterprise Stage runs sequencially no matter how many nodes are configured in the APT_CONFIG_FILE. I usually use more than one Oracle stage to read the same table if parallel reading is needed.
Posted: Sun Mar 30, 2008 9:11 pm
by ray.wurlod
This is as documented for the Oracle Enterprise stage. If you specify a Partition Table property it will execute in parallel provided that the table is appropriately partitioned.