> I was under the impression that this utility could consolidate trace
> files generated by versions of Oracle earlier than 10g, I cannot
> however get the utility to consolidate on the basis of module and
> action, only sessionid. The trace files are from 9206.
This is because of a little bit different format of trace files.
Here's how
exec dbms_application_info.set_module('my_module','my_action');
mapped to trace in 9i:
APPNAME mod='my_module' mh=2140208971 act='my_action' ah=3451251578
And here's the same command for 10g:
*** ACTION NAME:(my_action) 2005-03-22 00:17:39.186
*** MODULE NAME:(my_module) 2005-03-22 00:17:39.186
Btw, along with my profiler (link in signature) I distribute utility
called trcsess.py. Right now it works only with 'session id' but I
will modify it to recognize module/action for 9i trace files.
--
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 21 2005 - 13:52:27 CST
