Hi all,
I am stuck from tracing file by using dbms_monitor.serv_mod_act_trace_enable
I coded like below:
SYS>
grant execute on dbms_monitor to dev;
grant execute on dbms_application_info to dev;
dev>
alter session set tracefile_identifier='winsplay';
begin
dbms_application_info.set_module(
module\_name => 'winsplay',
action\_name => 'my job'
);
end;
/
SYS>
declare
begin
dbms_monitor.serv_mod_act_trace_enable(
service\_name => 'winsplay',
module\_name => dbms\_monitor.all\_modules,
action\_name => dbms\_monitor.all\_actions,
waits => true,
binds => true
);
end;
/
With above setting, I can see trace list working on from querying select * from dba_enabled_traces;
But that's all. Where do I go to check statistics, execution plans, bind variables, wait events ??
I checked the location containing trace files. But there is no relevant file.
(In Window, C:\oraclexe\app\oracle\diag\rdbms\xe\xe\trace)