OraFAQ Forum: Performance Tuning » Complete sql_text with DBMS_XPLAN.DISPLAY

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)

Fri, 19 December 2014 02:21

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.

Fri, 19 December 2014 03:14

John Watson
Messages: 8964
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: Sun Feb 02 17:55:13 CST 2025