Full sql text
708774Nov 30 2009 — edited Dec 1 2009Hi all, I have this script but it doesn't give me the full sql text, what am I doing wrong?
select sql_text, executions, rows_processed
from gv$sqlarea
where address = ( select sql_address
from v$session
where sid = &&sid
and inst_id = &&node)
/
select id,type,flags,sdctl,sortcol,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c1
4 from (select toc.tocid id,toc.etype type,toc.toc_flags flags,toc.toc_sdctl sdc
tl,case when linktoc.etype>=0 then 1 else 0 end isfolder,linktoc.toc_color sortc
ol,toc.toc_comment as c1,toc.created as c2,toc.creator as c3,toc.name as c4,toc.
etype as c5,case when linktoc.etype = 0 and linktoc.rfid = linktoc.tocid then 32
0 when linktoc.etype = 0 and bitand(linktoc.toc_flags, 1) = 1 then 257 when link
toc.etype = 0 then 256 when linktoc.etype = 1 then 384 when (linktoc.edoc_mime i
s not null or linktoc.edoc_ext is not null) and bitand(linktoc.toc_flags, 1) = 1
then 17 when linktoc.edoc_mime is not null or linktoc.edoc_ext is not null then
16 when bitand(linktoc.toc_flags, 1) = 1 then 1 else 0 end as c6,toc.tocid as c
7,case when bitand(linktoc.toc_flags, 1) = 1 then 1 else 0 end as c8,case when b
itand(linktoc.toc_flags, 4096) = 4096 then 1 else 0 end as c9,toc.native_languag
e as c10,toc.modified as c11,toc.toc_own
7 73