I need to see the actual value of bind variables, but not by using 10046 Event Trace which writes to trace file. The goal is to write a script , but the following script got me nowhere:
declare
text varchar2(1024);
tracef utl_file.file_type;
begin
tracef:=utl_file.fopen('/aviv/app/oracle/admin/work/udump','bind.trc','w');
text:='';
FOR cr in
(select q.sql_text line, c.curno cno
from v$sql q, v$sql_cursor c
where q.address=c.parent_handle )
LOOP
text:=' Cursor#='||cr.cno||' SQL='||cr.line||' Bind Vars=';
FOR cr2 in
(select cursor_num,position,datatype, value from v$sql_bind_data
where value is not null and cursor_num=cr.cno)
LOOP
text:=text||' position:'||cr2.position||' type:'|| cr2.datatype||' Value=' || cr2.value;
END LOOP;
utl_file.put_line(tracef,text);
END LOOP;
end;

need to see value of bind variables of other sessions.

Thanks

Hi
The main reason the Trace is not the option is very simple. You have to analyze the trace files, which are not very readble and control your disk space.
Does anyone have experience with LogMiner ? Can it be the answer ?