Home » RDBMS Server » Performance Tuning » Complete sql_text with DBMS_XPLAN.DISPLAY_CURSOR (Oracle SE 11.2.0.4.4 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
Malakay79
Messages: 41
Registered: September 2007
Member
Hi,
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?

Thanks.

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: 8922
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: Thu Mar 28 11:01:22 CDT 2024