Performance while reading from hash file
Posted: Sat Feb 12, 2005 4:06 pm
I have a job that has been designed as below:
Oracle Stage ---> Transformer ----> Transformer ----> Transformer ----> HashFile ------> Transformer ---> Transformer --- > Oracle Stage.
These various transformers have look-ups from hash files. When I run the job, data moves from the first Oracle stage through the transformers to the hash file. Until all the data are written to the hash file, the read process from the hash file to the final Oracle stage does not start.
This job has Inter-process buffer enabled at the job level. The unix server has 2 CPUs. My understanding is that at least 2 processes can run simultaneously with 2 CPUs. I am of the impression that the first OCI stage to the hash file is one process and from the hash file to the destination OCI stage is the second process. SO why are not these processes running at the same time?
I will appreciate any help in this regard.
Thanks.
Oracle Stage ---> Transformer ----> Transformer ----> Transformer ----> HashFile ------> Transformer ---> Transformer --- > Oracle Stage.
These various transformers have look-ups from hash files. When I run the job, data moves from the first Oracle stage through the transformers to the hash file. Until all the data are written to the hash file, the read process from the hash file to the final Oracle stage does not start.
This job has Inter-process buffer enabled at the job level. The unix server has 2 CPUs. My understanding is that at least 2 processes can run simultaneously with 2 CPUs. I am of the impression that the first OCI stage to the hash file is one process and from the hash file to the destination OCI stage is the second process. SO why are not these processes running at the same time?
I will appreciate any help in this regard.
Thanks.