OraFAQ Forum: Client Tools » How do you Print an Explain Plan from SQL Developer?

Home » Other » Client Tools » How do you Print an Explain Plan from SQL Developer?

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

How do you Print an Explain Plan from SQL Developer? [message #438022]

Wed, 06 January 2010 15:55

mr_hotshot_818
Messages: 25
Registered: October 2009

Junior Member

I've generated an Explain Plan using Oracle SQL Developer but cannot print the output. How do you Print an Explain Plan from SQL Developer?

Report message to a moderator

Re: How do you Print an Explain Plan from SQL Developer? [message #438034 is a reply to message #438022]

Wed, 06 January 2010 21:40

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

File -> Print.

Click on SQL Worksheet -> Only sql will get printed.
Click on the first operation in the Explain plan window -> Only explain plan will get printed.

I didn't find any other option to print both and fully.

By
Vamsi

Report message to a moderator

Re: How do you Print an Explain Plan from SQL Developer? [message #438232 is a reply to message #438034]

Thu, 07 January 2010 11:21

mr_hotshot_818
Messages: 25
Registered: October 2009

Junior Member

It doesn't work. Only part of the Explain Plan is printed, not the entire plan.

Thanks

Report message to a moderator

Re: How do you Print an Explain Plan from SQL Developer? [message #438233 is a reply to message #438022]

Thu, 07 January 2010 11:22

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

You could always generate it in sqlplus and then print that.
I find the sqlplus version easier to read anyway.

Report message to a moderator

Re: How do you Print an Explain Plan from SQL Developer? [message #438255 is a reply to message #438232]

Thu, 07 January 2010 12:29

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

Senior Member
Account Moderator

mr_hotshot_818 wrote on Thu, 07 January 2010 18:21

Only part of the Explain Plan is printed, not the entire plan.

Not entire vertically or horizontally? I suppose the latter; if so, would it help if you set paper orientation to "Landscape" (instead of "Portrait")?

Report message to a moderator

Re: How do you Print an Explain Plan from SQL Developer? [message #438289 is a reply to message #438255]

Thu, 07 January 2010 17:44

mr_hotshot_818
Messages: 25
Registered: October 2009

Junior Member

Neither vertically nor horizontally. Surprisingly the portrait prints more than landscape, even though the plan is in landscape layout.

Report message to a moderator

Re: How do you Print an Explain Plan from SQL Developer? [message #438290 is a reply to message #438289]

Thu, 07 January 2010 17:48

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

So it is cut off at the LEFT or at the BOTTOM?

And does it go right to the printer margins?

Report message to a moderator

Re: How do you Print an Explain Plan from SQL Developer? [message #438388 is a reply to message #438290]

Fri, 08 January 2010 09:48

mr_hotshot_818
Messages: 25
Registered: October 2009

Junior Member

It cuts off at the bottom. It basically looks like a printed screen capture. If I scroll to the remaining pieces of the document it will print that particular segment of the plan.

Report message to a moderator

Re: How do you Print an Explain Plan from SQL Developer? [message #438398 is a reply to message #438388]

Fri, 08 January 2010 11:17

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Did you follow the same way exactly?

In my post, I've asked you to click on the first operation, not on operation tab.
After clicking on the first operation, did you see any blue bar?

When I mean "first operation", SELECT, UPDATE or DELETE.
Basically wherever you don't bother to see a blue bar.

This is annoying, but I didn't find any other way.

By
Vamsi

Report message to a moderator

Re: How do you Print an Explain Plan from SQL Developer? [message #438401 is a reply to message #438398]

Fri, 08 January 2010 11:59

mr_hotshot_818
Messages: 25
Registered: October 2009

Junior Member

Yes. Performed those exact steps and tried others. I also tried highlighting the entire plan. I tried changing the layout (eg Landscape v. Portrait). I tried changing the margins. Nothing prints the entire explain plan. Its basically a print of a screen capture.

Report message to a moderator