Home » SQL & PL/SQL » Client Tools » How do you Print an Explain Plan from SQL Developer?
How do you Print an Explain Plan from SQL Developer? [message #438022] Wed, 06 January 2010 15:55 Go to next message
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?
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 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
cookiemonster
Messages: 12320
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.
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 Go to previous messageGo to next message
Littlefoot
Messages: 20824
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")?
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
ThomasG
Messages: 3184
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?
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
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 Go to previous messageGo to next message
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.
Re: How do you Print an Explain Plan from SQL Developer? [message #438402 is a reply to message #438401] Fri, 08 January 2010 12:06 Go to previous messageGo to next message
BlackSwan
Messages: 24903
Registered: January 2009
Senior Member
Those who live by the GUI, die by the GUI.
Long live SQLPLUS!
Re: How do you Print an Explain Plan from SQL Developer? [message #438405 is a reply to message #438401] Fri, 08 January 2010 13:50 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Not sure why!!!
I'm able to print properly.
My version is:
Quote:
CVS Version Internal to Oracle SQL Developer (client-only)
Java(TM) Platform 1.5.0_06
Oracle IDE 1.5.3.57.83
Versioning Support 1.5.3.57.83
Anyway, SQL*PLUS is the best.

By
Vamsi
Previous Topic: how can i login as sysdba @ isqlplus
Next Topic: Toad Schema Browser Multi Tabs
Goto Forum:
  


Current Time: Sat Sep 24 19:48:09 CDT 2016

Total time taken to generate the page: 0.27055 seconds