Re: Capturing DBMS_XPLAN.DISPLAY output

From: Stephen Barr <ascaroth969_at_yahoo.co.uk>
Date: Thu, 22 Jun 2006 16:31:04 +0100 (BST)
Message-ID: <20060622153104.11306.qmail@web86901.mail.ukl.yahoo.com>

Very helpful.

Thanks.

• Jurijs Velikanovs <j.velikanovs_at_gmail.com> wrote:

> Try to say loudly:
>
> ORACLE ! PLEASE ! SAVE THIS ARRAY OF VARCHAR2 TYPE
> STRINGS IN CLOB!
>
> If it doesn't help try to thing WHY
>
> Yury
>
>
> 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
> >
> >
> >
>
>
> --
> Yury
> +44 7738 013090 (GMT)
> ============================================
> http://otn.oracle.com/ocm/jvelikanovs.html
>
                                  

---

Win tickets to the 2006 FIFA World Cup Germany with Yahoo! Messenger. http://advision.webevents.yahoo.com/fifaworldcup_uk/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 22 2006 - 10:31:04 CDT