Following is the pictorial view of an under performing job I have:
![Image](http://img255.imageshack.us/img255/4388/28373180.jpg)
Green-> Hashed Files
Orange-> Transformer
Red -> OCI Stage
Info about jobs:
---------------------------------------------------------------------------
OCI:
Source count records < 400K
Array Size in OCI =1000, Transaction size =0, Transaction handling 10k
---------------------------------------------------------------------------
HASHED FILES:
All Hashed files Type 18
'Allow Stage write cache' is enabled, Modulus is 1, Separation is 3
Hashed file key column varies from 1 to 3
Private caching enabled, cache size (256MB)
Data in Hashed files is not growing; max row in Hashed file is < 2k
Hashed files have only required column and column width is defined as required.
---------------------------------------------------------------------------
TRANSFORMER:
Four custom routines are used for data quality check on ~50 source columns
---------------------------------------------------------------------------
SERVER:
Memory Size: 29696 MB
Good Memory Size: 29696 MB
Number Of Processors: 4
Processor Clock Speed: 1648 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
---------------------------------------------------------------------------
Job performance is 50rows/sec. What can I do to improve the job performance
Let me know if you guys need any other info.
-
LD