Hi ,
I want to get the full sql stmt running by end user.I tried
v$sqltext;
v$sqlarea;
v$sql;
v$sqltext_with_newlines;
But none of the views is giving me fill sql statement only partial....Can u pls help..?
Printable View
Hi ,
I want to get the full sql stmt running by end user.I tried
v$sqltext;
v$sqlarea;
v$sql;
v$sqltext_with_newlines;
But none of the views is giving me fill sql statement only partial....Can u pls help..?
V$SQLTEXT should provide entire SQL. BTW what's your Oracle Version?
try changing the column format
columnformat a500;
SQL> col SQL_TEXT format a50
SQL> select SQL_TEXT from v$sqltext where SQL_ID='6hwjmjgrpsuaa';
SQL_TEXT
--------------------------------------------------
, req_reason
nqueue_statistics where total_req# != 0 order
by eq_type
#, succ_req#, failed_req#, cum_wait_time, event
# from v$e
:instance_number, eq_type, req_reason, total_re
q#, total_wait
led_req#, cum_wait_time, event#) select :sn
SQL_TEXT
--------------------------------------------------
ap_id, :dbid,
eq_type, req_reason, total_req#, total_wait#,
succ_req#, fai
insert into wrh$_enqueue_stat (snap_id, dbid, in
stance_number,
7 rows selected.
SQL> col SQL_TEXT format a10000
SQL> select SQL_TEXT from v$sqltext where SQL_ID='6hwjmjgrpsuaa';
SQL_TEXT
--------------------------------------------------------------------------------
, req_reason
nqueue_statistics where total_req# != 0 order by eq_type
#, succ_req#, failed_req#, cum_wait_time, event# from v$e
:instance_number, eq_type, req_reason, total_req#, total_wait
led_req#, cum_wait_time, event#) select :snap_id, :dbid,
eq_type, req_reason, total_req#, total_wait#, succ_req#, fai
insert into wrh$_enqueue_stat (snap_id, dbid, instance_number,
I see, very useful huh? :confused:
Can't you see don't matter if you format the column a1Trillion the column would always hold no more than 64 chars? :rolleyes:
Why don't you do it the easy -right way and stop confusing the poster?
:cool:Code:select sql_text
from v$sqltext
where sql_id='???'
order by piece;
thanks for that...sorry if i created confusion.....