Home » RDBMS Server » Performance Tuning » Complete sql_text with DBMS_XPLAN.DISPLAY_CURSOR (Oracle SE on Linux Red Hat 6)
Complete sql_text with DBMS_XPLAN.DISPLAY_CURSOR [message #630058] Fri, 19 December 2014 02:21 Go to next message
Messages: 41
Registered: September 2007
I use this select to get the explain plan for my select:

set lines 350
set pages 50000
set long 1000000000

select * from table(DBMS_XPLAN.DISPLAY_CURSOR('&SQL_ID.','&CHILD_NUMBER',format=>'ADVANCED') );

But I don't see the complete sql_text. Is there a way to see the complete sql_text with DBMS_XPLAN.DISPLAY_CURSOR procedure?


Re: Complete sql_text with DBMS_XPLAN.DISPLAY_CURSOR [message #630059 is a reply to message #630058] Fri, 19 December 2014 03:14 Go to previous message
John Watson
Messages: 8935
Registered: January 2010
Location: Global Village
Senior Member
No way that I know of (which does not mean that there is not a way) so I think you will have to retrieve the statement from v$sql.full_text
Previous Topic: Remote query performance in BO reports
Next Topic: Library cache (PIPES)
Goto Forum:

Current Time: Wed May 29 03:31:44 CDT 2024