Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Capturing DBMS_XPLAN.DISPLAY output

Re: Capturing DBMS_XPLAN.DISPLAY output

From: Stephen Barr <ascaroth969_at_yahoo.co.uk>
Date: Thu, 22 Jun 2006 16:48:23 +0100 (BST)
Message-ID: <20060622154823.27874.qmail@web86905.mail.ukl.yahoo.com>


Many thanks.

> No need to be rude. You can create custom procedure
> to concatenate and
> stream output from "select * from
> table(dbms_xplan.display)" into a single
> blob value.
>
> If you don't need a single value use:
>
> create table xplan_output as
> select * from table(dbms_xplan.display);
>
> - Vlad
>
> On 6/22/06, Stephen Barr <ascaroth969_at_yahoo.co.uk>
> wrote:
> >
> > How can I capture DBMS_XPLAN.DISPLAY output into a
> > table - e.g. as a CLOB?
> >
> > select * from table(dbms_xplan.display);
> >
> >
> >
> >
>



> > All New Yahoo! Mail – Tired of Vi_at_gr@! come-ons?
> Let our SpamGuard protect
> > you. http://uk.docs.yahoo.com/nowyoucan.html
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
                

To help you stay safe and secure online, we've developed the all new Yahoo! Security Centre. http://uk.security.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 22 2006 - 10:48:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US