Home » SQL & PL/SQL » Client Tools » Explain Plan problem - oracle toad (Oracle Toad)
Explain Plan problem - oracle toad [message #536039] Mon, 19 December 2011 01:36 Go to next message
karafokas
Messages: 1
Registered: December 2011
Junior Member
Hello,

I am having trouble executing a query in toad. I am using 15 tables from multiple locations (DMART tables and another schema). The problem is when i try to use the explain plan, the cost is 778 and 442 Bytes, the actual output is 1 line but it takes 20 minutes to execute. Can you give me some advice on where to start looking for the problem. I know that my sql is correct since the actual output is correct, but it takes so long.

Thank you in advance

George
Re: Explain Plan problem - oracle toad [message #536045 is a reply to message #536039] Mon, 19 December 2011 02:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can you give me some advice on where to start looking for the problem

Through away TOAD and start using SQL*Plus.

Regards
Michel
Re: Explain Plan problem - oracle toad [message #536061 is a reply to message #536045] Mon, 19 December 2011 02:37 Go to previous message
Roachcoach
Messages: 1180
Registered: May 2010
Location: UK
Senior Member
In addition to that, it reads like a performance issue, rather than a tool issue Smile


If I'm right, add this detail http://www.orafaq.com/forum/t/84315/153040/ and hopefully a mod will move the thread Smile



Also - stop reading cost.
Previous Topic: How to connect to Oracle 7 using Oracle client
Next Topic: removal of ORACLE_BASE/rbdms/ORACLE_SID/alert.xml files
Goto Forum:
  


Current Time: Tue Jul 29 17:02:48 CDT 2014

Total time taken to generate the page: 0.07181 seconds