SQL & PL/SQL

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!

Query performance : TOAD Vs SQL Plus, and caching of query output

644210Nov 26 2008 — edited Nov 26 2008

Hi,
I have one query which takes more than 2 minutes in TOAD, but the same one takes less than 30 secs when executed in SQL Plus. Can some body please tell me why the performance is so different in the two. Is this a known issue? Can i get the actual time required for a query?

Also when I execute the same query in TOAD for the second time in succession, the execution time reduces drastically from 2 mins to 10 secs. Does caching occur in TOAD? Can I disable it. I am using TOAD for Oracle, Version 9.0.0.160.

Thanks,
Rahul.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2008

Added on Nov 26 2008

4 comments

1,038 views