Database Tuning (MOSC)

MOSC Banner

11gR2 Trace file(s) not created for dbms_monitor.serv_mod_act_trace_enable call

edited May 14, 2015 5:54AM in Database Tuning (MOSC) 4 commentsAnswered ✓

This question relates to Oracle Enterprise Edition 11.2.0.4 on AIX.

I'm trying to help tune an application where we have application servers are firing queries and calls to PL/SQL package procedures and functions at the database.  We have most of their calls doing the latter, so I've edited the called packages to include a simple dbms_application_info setting line right at the top of each procedure function:

...

BEGIN

  dbms_application_info.set_module(module_name=>'$$PLSQL_UNIT',action_name=>'$$PLSQL_LINE');

...

In tests, I have used "dbms_monitor.serv_mod_act_stat_enable(service_name=>'SYS$USERS',module_name=>'MYPACK');"  and can see the resulting entries in the

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center