OraFAQ Forum: Client Tools » Explain plan Using toad and SQL Developer

Members

Help

Home

Home » SQL & PL/SQL » Client Tools » Explain plan Using toad and SQL Developer (oracle 10g,)

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

Explain plan Using toad and SQL Developer [message #411361]

Fri, 03 July 2009 04:26

balaji1482
Messages: 298
Registered: July 2007
Location: INDIA

Senior Member

Hi,

How to find explain plan of a query in oracle using TOAD(any) and SQL Developer(any)?

If there any functioanl key to find out please let me know.

Regards,
Balaji

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411363 is a reply to message #411361]

Fri, 03 July 2009 04:33

ashoka_bl
Messages: 315
Registered: November 2006
Location: Bangalore

Senior Member

Have you set the PLAN_TABLE

Go to View->Options->Oracle->General in TOAD to determine whether you set the plan_table

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411366 is a reply to message #411363]

Fri, 03 July 2009 04:44

balaji1482
Messages: 298
Registered: July 2007
Location: INDIA

Senior Member

plan table is all set .please let me know how to view explain plan using function key.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411367 is a reply to message #411366]

Fri, 03 July 2009 04:46

ashoka_bl
Messages: 315
Registered: November 2006
Location: Bangalore

Senior Member

how do you do it normally ?? in SQL*PLUS ?? the similar way

explain plan for select * from emp;

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411370 is a reply to message #411361]

Fri, 03 July 2009 05:04

delna.sexy
Messages: 384
Registered: December 2008
Location: Surat

Senior Member

Alternatively,
SET AUTOTRACE ON, a SQL Plus command.

regards,
Delna

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411372 is a reply to message #411366]

Fri, 03 July 2009 05:15

Frank
Messages: 7240
Registered: March 2000

Senior Member

Ever heard of google.com?
The third hit explains it in Google's overview page..
Being lazy can be a good thing for developers, but this is waay waay too far.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411373 is a reply to message #411370]

Fri, 03 July 2009 05:15

balaji1482
Messages: 298
Registered: July 2007
Location: INDIA

Senior Member

Thanks for your answer.

Is there any other way to find explain plan in TOAD,SQL Developer like using function key somethig like that?

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411374 is a reply to message #411373]

Fri, 03 July 2009 05:16

Frank
Messages: 7240
Registered: March 2000

Senior Member

balaji1482 wrote on Fri, 03 July 2009 12:15

Thanks for your answer.

Is there any other way to find explain plan in TOAD,SQL Developer like using function key somethig like that?

Yes: GOOGLE

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411386 is a reply to message #411372]

Fri, 03 July 2009 05:55

ashoka_bl
Messages: 315
Registered: November 2006
Location: Bangalore

Senior Member

balaji,

What's your intension understand the EXPLAIN PLAN for your query or doing research on what are the possibilities to get the Explain Plan.

I don't know why are you so keen about the function key, Concentrate on the solution.

By the way google.com is very good if you haven't heard of, I almost gave you the solution but still want to try then please go ahead

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411409 is a reply to message #411386]

Fri, 03 July 2009 07:28

hillbillyToad
Messages: 4
Registered: July 2009

Junior Member

Getting an execution plan in Toad is pretty straightforward.

In the editor, put your cursor on the statement you want explained. Then, either use the Ambulance button on the toolbar, or use the keyboard shortcut Ctrl+E.

The plan will show in the 'Explain Plan' tab below, next to the data grid.

I'm pretty sure SQL Developer borrowed the same keyboard shortcut Smile

There is a blog on ToadWorld.com customizing the look and feel (and content) of explain plans in Toad, do a Google on 'Customizing Data explain toadworld' to find it.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411420 is a reply to message #411409]

Fri, 03 July 2009 08:13

balaji1482
Messages: 298
Registered: July 2007
Location: INDIA

Senior Member

This is what the answer i was expecting ie the keyboard shortcut (ctrl+E). Earlier sometimes back i was using it and cannot remember now.

I searched in Google for my answer but was not able to find out.

Thanks for your answer.

Regards,
Balaji

[Updated on: Fri, 03 July 2009 08:17]

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411421 is a reply to message #411361]

Fri, 03 July 2009 08:22

ashoka_bl
Messages: 315
Registered: November 2006
Location: Bangalore

Senior Member

Hey Congrats !!! Finally you did it without wasting time in googling....

Even i did some googling and found a page for you !!!

http://www.mandsconsulting.com/toad-sql-editor-useful-shortcuts

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411460 is a reply to message #411421]

Sat, 04 July 2009 01:45

balaji1482
Messages: 298
Registered: July 2007
Location: INDIA

Senior Member

Actually i was in need of prompt answer after spending time in Google for few minutes.It was an urgent task .

anyway thanks for spending your precious time in googling and many thanks to hillbily

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411507 is a reply to message #411460]

Sat, 04 July 2009 08:06

pablolee
Messages: 1628
Registered: May 2007
Location: Scotland

Senior Member

Quote:

It was an urgent task .

How on earth could finding the shortcut key to generate an explain plan in TOAD be considered urgent?

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411530 is a reply to message #411460]

Sat, 04 July 2009 14:12

Littlefoot
Messages: 9166
Registered: June 2005
Location: Croatia, Europe

Senior Member

@balaji1482, you know, there's that "Help" thing (available in TOAD too) which gets open once you press the F1 key (which is in many / most applications mapped to "Help").

Then there's the "Search" tab. You are (actually, were) supposed to put "explain plan" in there and press <Enter>. Choose the very first topic which talks about "Explain plan". There's all about the ambulance icon, as well as <Ctrl + E>.

The whole process lasted half a minute (for me), and almost 4 (four) hours for you. One doesn't have to be ./fa/5851/0/

in order to find such information.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #411604 is a reply to message #411530]

Sun, 05 July 2009 23:50

ashoka_bl
Messages: 315
Registered: November 2006
Location: Bangalore

Senior Member

@Littlefoot,

I don't have TOAD (Currently...According to Michel's suggestion Smile

) and it took me not more than 10 min to search in Google Smile

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #427571 is a reply to message #411361]

Fri, 23 October 2009 05:07

Dont_Be_A_Dork
Messages: 1
Registered: October 2009

Junior Member

Hi Frank and ashoka_bl! You know, this forum could do without your "holier than thou" replies. If you're not here to help then why don't you both piss off.

Report message to a moderator

Re: Explain plan Using toad and SQL Developer [message #427572 is a reply to message #427571]

Fri, 23 October 2009 05:10

Frank
Messages: 7240
Registered: March 2000

Senior Member

Considering this being your first and only contribution to this forum so far, I would say this is a typical case of the pot calling us black..

Report message to a moderator

Previous Topic:	readonly TOAD...and a lacy guy
Next Topic:	Show all fetched rows?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 7 21:26:00 CST 2009

Total time taken to generate the page: 0.50044 seconds

.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.