Re: your explain plan script

From: <tboss_at_bossconsulting.com>
Date: Sun, 18 Jul 2004 10:36:16 -0500 (EST)
Message-Id: <200407181536.i6IFaGr6061811@vegeta.p6m7g8.net>

Fwiw, Here's a script to neatly show plan_table output that I picked up somewhere or another. If someone claims ownership, i'd be more than happy to put in a "Copywright John Q Public 2001" message every time I use it :-)

column operation format a16
column options format a15
column object_name format a20
column id format 99

select lpad(' ',2*(level-1))||operation||' '||options||' '||object_name||' '||

decode(partition_id, NULL, '',
'PART:'||lower(partition_start||'-'||partition_stop))|| decode(optimizer, NULL, '', ' ['||optimizer||']')|| decode(id,0,' Cost=' ||nvl(position, 0)|| ' Rows=' ||nvl(cardinality,0)|| ' Bytes='||nvl(bytes, 0)) "Query Plan" from plan_table where statement_id = 'XXX' start with id = 0 and statement_id = 'XXX' connect by prior id = parent_id and statement_id = 'XXX'

Todd

>
> Wolfgang,
>
> Any chance I could "borrow" your script to show the execution
> plan from the plan table?
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by
> email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article,
> or send email to Oracle-article-request_at_gennick.com and
> include the word "subscribe" in either the subject or body.
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sun Jul 18 2004 - 09:31:43 CDT