dbms_monitor.SERV_MOD_ACT_TRACE_ENABLE cannot trace service in job class

I have a issue about dbms_monitor.SERV_MOD_ACT_TRACE_ENABLE. It can trace sqlplus query. But it cannot trace service in job class.

I am appreciated if anyone can help.

Below is test steps

1. add service srvctl add service -d rdb -s oltp -r rdb1 -a rdb2
2. startup service srvctl start service -d rdb -s oltp
3. using service in tnsnames.ora oltp = (DESCRIPTION =
   (LOAD_BALANCE = ON)
   (FAILOVER = ON)
   (ADDRESS = (PROTOCOL = TCP)(HOST = rdb1)(PORT = 1521))
   (ADDRESS = (PROTOCOL = TCP)(HOST = rdb2)(PORT = 1521))
   (CONNECT_DATA =
   (SERVICE_NAME = OLTP) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 1) ) ) )
4. open trace dbms_monitor.SERV_MOD_ACT_TRACE_ENABLE('oltp');
5. run one query and check trace file

sqlplus /nolog
conn sys/sys_at_oltp as sysdba
select * from test;

in $ORACLE_BASE/admin/rdb/udump/rdb1_ora_22960.trc There is the query: select * from test

6. create job class with service
BEGIN
  DBMS_SCHEDULER.create_job_class(
    job_class_name => 'OLTP_JOB_CLASS',
    service => 'OLTP');
END;
/

7. create job

BEGIN
  DBMS_SCHEDULER.create_job (

    job_name        => 'my_job',
    job_type        => 'PLSQL_BLOCK',
    job_action      => 'insert into test values (sysdate);',
    start_date      => SYSTIMESTAMP,
    repeat_interval => 'FREQ=MINUTELY; INTERVAL=10;',
    job_class       => 'OLTP_JOB_CLASS',
    end_date        => SYSDATE + 7,
    enabled         => TRUE,
    comments        => 'Job linked to the OLTP_JOB_CLASS.');

8. very result the job

select to_char(c1, 'YYYY-MM-DD HH24:MI') from test;

9. check trace file
in $ORACLE_BASE/admin/rdb/udump/ directory, there is no query like insert into test values (sysdate);

Thanks in advance
Jacky Received on Sun May 16 2010 - 05:48:17 CDT