OraFAQ Forum: SQL & PL/SQL » Formatting html file for an explain plan

Home » SQL & PL/SQL » SQL & PL/SQL » Formatting html file for an explain plan

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

Formatting html file for an explain plan [message #607011]

Sat, 01 February 2014 07:29

Malakay79
Messages: 41
Registered: September 2007

Member

I would like to create a formatting html file for an explain plan.
Oracle 11.2.0.3 on Linux.

I can't use DBMS_XPLAN.DISPLAY_PLAN because I get the info from the memory cursor and and I can't set the statement_id.
I know there is the "SET MARKEUP HTML" option in sqlplus, but the output is not formatted and the is no indentation in the html file.
To get the plan I use:

SELECT *  FROM table (DBMS_XPLAN.DISPLAY_CURSOR(sql_id => '6xbrn498qgr6x'));

How can I do that?

Report message to a moderator

Re: Formatting html file for an explain plan [message #607015 is a reply to message #607011]

Sat, 01 February 2014 08:21

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Directly query V$SQL_PLAN.

Regards
Michel

Report message to a moderator

Previous Topic:	Send file to client
Next Topic:	where is oracle built in package stored

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:33:23 CDT 2024