How to increase the number of nodes in Parallel Job

[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

[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.

[Yuan_Edward]

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.

[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.