OraFAQ Forum: Client Tools » empty explain pane in TOAD and SQLDeveloper

Home » Other » Client Tools » empty explain pane in TOAD and SQLDeveloper

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

empty explain pane in TOAD and SQLDeveloper [message #400203]

Mon, 27 April 2009 02:44

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: empty explain pane in TOAD and SQLDeveloper [message #400216 is a reply to message #400203]

Mon, 27 April 2009 03:21

Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium

Member

Ok thanks,

tried that
same result

Report message to a moderator

Re: empty explain pane in TOAD and SQLDeveloper [message #400225 is a reply to message #400203]

Mon, 27 April 2009 03:53

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

Report message to a moderator

Re: empty explain pane in TOAD and SQLDeveloper [message #400334 is a reply to message #400225]

Mon, 27 April 2009 12:16

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: empty explain pane in TOAD and SQLDeveloper [message #411411 is a reply to message #400334]

Fri, 03 July 2009 07:38

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'.

Report message to a moderator

Previous Topic:	Can I download SQL+ from Oracle website?
Next Topic:	Difference in precision in sqlplus and excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 01:02:53 CST 2025