Performance Statistics in designer With Oracle database

ray.wurlod · Post by **ray.wurlod** » Thu Aug 14, 2008 4:13 pm

"Performance statistics" in Designer are only cosmetic anyway (prefer to rely on the row counts available through Monitor). Did you enable display of these (from the Diagram menu) for this job?

You might also post your job design, so we can see what other stages may be involved. For example, if you have a Copy stage preceding the Oracle stage, and the Copy stage is optimized out when the score is composed, then you will never see row count on the output of the Copy stage (because no copy operator is executed).

rpdeepak.kumar · Post by **rpdeepak.kumar** » Fri Aug 15, 2008 7:00 am

Thanks for the reply.

Yes its enable in the tool. Only thing when ever i use Oracle stage ,it not showing the Performance statistics. I thing it may due to oracle connection problem to datastage.

Thanks

chulett · Post by **chulett** » Fri Aug 15, 2008 7:39 am

If the job runs successfully, what 'Oracle connection problem' could you be having? Post your job design, listing all stages in it, so we know what other stages are in play.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 15, 2008 5:14 pm

No idea. What does your job log tell you about the connection?

ray.wurlod · Post by **ray.wurlod** » Fri Aug 15, 2008 5:15 pm

No idea. What does your job log tell you about the connection?

Unless you are using Oracle for the XMETA common metadata repository, Oracle connections and performance statistics should be completely unrelated.