Oracle Database Discussions

Several weeks ago I ran a diagnostic script I found in Metalink document #733655.1. That script included commands:

SQL> -- disable flush and purge while we gather information
SQL>
SQL> alter system set "_swrf_mmon_flush" = false;
.
.
.
SQL> -- re-enable flush and purge
SQL>
SQL> alter system set "_swrf_mmon_flush" = true;


After running the script I started getting hourly trace files in the bdump directory. No error code appears in the files.


*** ACTION NAME:(Auto-Flush Slave Action) 2009-04-07 18:00:55.316
*** MODULE NAME:(MMON_SLAVE) 2009-04-07 18:00:55.316
*** SERVICE NAME:(SYS$BACKGROUND) 2009-04-07 18:00:55.316
*** SESSION ID:(1229.30240) 2009-04-07 18:00:55.316
Setting gid=2, LAFBucn=47, LAFTime=-639887744

***Begin dumping ALEM list. gid=2, Laftm=-639887744.
Elem=700000145bcbee0, ieid=0, mid=2104, fcbm=1, endfbuc=0, endftm=-1, chbbuctm
=-640169767

Setting gid=7, LAFBucn=2, LAFTime=-639905751

***Begin dumping ALEM list. gid=7, Laftm=-639905751.

Setting gid=1, LAFBucn=47, LAFTime=-639887744

***Begin dumping ALEM list. gid=1, Laftm=-639887744.

Setting gid=4, LAFBucn=47, LAFTime=-639887744

***Begin dumping ALEM list. gid=4, Laftm=-639887744.


An Oracle support person advised me thus:

Turn off AWR flushing with:
alter system set "_swrf_mmon_flush"=false;

To turn off the trace files:
execute dbms_monitor.serv_mod_act_trace_disable (service_name=>'SYS$BACKGROUND');


I executed command "alter system set "_swrf_mmon_flush"=false;" and creation of the trace files stopped. Unfortunately, that also stopped creation of the hourly snapshots in the AWR of Enterprise Manager Grid Control (10.2.0.2).

I reversed course by running command "alter system set "_swrf_mmon_flush"=true;". The hourly reports in AWR are again being produced, but so are the trace files.

Execution of command "SQL> execute dbms_monitor.serv_mod_act_trace_disable (service_name=>'SYS$BACKGROUND');"
produced the message:

BEGIN dbms_monitor.serv_mod_act_trace_disable (service_name=>'SYS$BACKGROUND'); END;

*
ERROR at line 1:
ORA-13852: Tracing for service(module/action) SYS$BACKGROUND is not enabled
ORA-06512: at "SYS.DBMS_MONITOR", line 99
ORA-06512: at line 1


Does anyone know what I must do to stop the hourly creation of trace files but continue the creation of the hourly AWR snapshots?

Thank you,
Bill