DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interesting Performance problem..Query runs fast in TOAD and Reports 6i..

514497Jul 24 2006 — edited Jul 31 2006

Hi All,

I have a query which runs with in 4 mins in Toad and also report 6i. But when ran through applications takes 3 to 4 hrs to complete normal.This report fetches huge amount of data will that be the reason for poor performance?? I am unable to figure that out. I was able to avoid full table scan on the tables used. But still have the problem.

Any suggestions please.

Thank you in advance.
Prathima

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2006

Added on Jul 24 2006

#reports

19 comments

1,027 views