Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Capturing DBMS_XPLAN.DISPLAY output

Stephen Barr

2006-06-22

Replies:

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@gr@(protected)
--
http://www.freelists.org/webpage/oracle-l


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.