Usage of Read Cache Size and Write Cache Size
Posted: Tue May 24, 2011 3:24 pm
Hello,
I am analyzing a set of Server jobs for performance analysis.
One of the jobs has a design as
Sequential file -> Transformer(Hashed file lookup) -> Transformer (hashed file lookup) -> Load Oracle table (DRS stage).
916990 records are passed into 2nd transformer and the lookup is against hashed file with 178678 records. The lookup and subsequent load to Oracle table (Array Size and Transaction size are 15000) takes close to 14 minutes. I am considering to raise the project default setting for Read cache size and Write cache size of 128 MB to higher like 256 MB.
Is this a good approach to improve performance?
Appreciate your inputs.
I am analyzing a set of Server jobs for performance analysis.
One of the jobs has a design as
Sequential file -> Transformer(Hashed file lookup) -> Transformer (hashed file lookup) -> Load Oracle table (DRS stage).
916990 records are passed into 2nd transformer and the lookup is against hashed file with 178678 records. The lookup and subsequent load to Oracle table (Array Size and Transaction size are 15000) takes close to 14 minutes. I am considering to raise the project default setting for Read cache size and Write cache size of 128 MB to higher like 256 MB.
Is this a good approach to improve performance?
Appreciate your inputs.