Home » Other » Client Tools » empty explain pane in TOAD and SQLDeveloper
empty explain pane in TOAD and SQLDeveloper [message #400203] Mon, 27 April 2009 02:44 Go to next message
Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium
Member
Hi all,

I use sqldeveloper 1.5.4.59.40 and DB is 11g
and TOAD, both exhibit the same problem


I don't get anything in the explain pane
sys.plan_table$ exists, public synonym plan_table exists
grant delete, insert, select, update on sys.plan_table$ to public; is also there
clicking explain tab shows empty pane (plan_table remains empty as well)
explain plan for select ...... does work :
[code]
select *
from table(dbms_xplan.display)
[code]
does work, as does
[code]
select *
from plan_table
[code]

any insights on this ?


Kr
Martin

[Updated on: Mon, 27 April 2009 02:55]

Report message to a moderator

Re: empty explain pane in TOAD and SQLDeveloper [message #400206 is a reply to message #400203] Mon, 27 April 2009 02:52 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hm, try to create the PLAN_TABLE in this schema (i.e. forget about the synonym).
Re: empty explain pane in TOAD and SQLDeveloper [message #400216 is a reply to message #400203] Mon, 27 April 2009 03:21 Go to previous messageGo to next message
Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium
Member
Ok thanks,

tried that
same result

Re: empty explain pane in TOAD and SQLDeveloper [message #400225 is a reply to message #400203] Mon, 27 April 2009 03:53 Go to previous messageGo to next message
Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium
Member
ok

silly me, it works in sql_developer
with standard sys.plan_table

it seems I only have a problem in TOAD
Re: empty explain pane in TOAD and SQLDeveloper [message #400334 is a reply to message #400225] Mon, 27 April 2009 12:16 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In that case, try to create another table using the CTAS:
CREATE TABLE toad_plan_table AS SELECT * FROM plan_table;
and see what happens.
Re: empty explain pane in TOAD and SQLDeveloper [message #411411 is a reply to message #400334] Fri, 03 July 2009 07:38 Go to previous message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

In Toad you have to go into the View > Options dialog and tell Toad WHAT plan table to use. Use the search window in the bottom and do a search on 'plan'.
Previous Topic: Can I download SQL+ from Oracle website?
Next Topic: Difference in precision in sqlplus and excel
Goto Forum:
  


Current Time: Thu Mar 28 03:34:16 CDT 2024