dbms_monitor.SERV_MOD_ACT_TRACE_ENABLE cannot trace service in job class
in [Oracle]
|
Prev: dbms_monitor.SERV_MOD_ACT_TRACE_ENABLE cannot trace service in job class
Next: Return rows as 1 line?
From: Steve Howard on 17 May 2010 07:06 On May 16, 6:48 am, lsllcm <lsl...(a)gmail.com> wrote: > Hi All, > > 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(a)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.'); > END; > / > > 8. very result the job > > select to_char(c1, 'YYYY-MM-DD HH24:MI') from test; > ------------------------------------- > 2010-05-16 17:17 > 2010-05-16 17:27 > > 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 Hi Jacky, What version? If 10.2.0.3, see... Bug 5658143 DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE cannot set trace ....on MOS. HTH, Steve
From: lsllcm on 17 May 2010 21:31 On 5¤ë17¤é, ¤U¤È7®É06¤À, Steve Howard <stevedhow...(a)gmail.com> wrote: > On May 16, 6:48 am, lsllcm <lsl...(a)gmail.com> wrote: > > > > > > > Hi All, > > > 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(a)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.'); > > END; > > / > > > 8. very result the job > > > select to_char(c1, 'YYYY-MM-DD HH24:MI') from test; > > ------------------------------------- > > 2010-05-16 17:17 > > 2010-05-16 17:27 > > > 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 > > Hi Jacky, > > What version? If 10.2.0.3, see... > > Bug 5658143 DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE cannot set trace > > ...on MOS. > > HTH, > > Steve- ÁôÂóQ¤Þ¥Î¤å¦r - > > - Åã¥Ü³Q¤Þ¥Î¤å¦r - Thanks, I will upgrade it to 10.2.0.4 and test
From: Mladen Gogala on 17 May 2010 21:50
On Mon, 17 May 2010 18:31:08 -0700, lsllcm wrote: > Thanks, I will upgrade it to 10.2.0.4 and test I would try 10.2.0.5 if I were you. No need to upgrade to the 2.5 years old version when you're upgrading. -- http://mgogala.byethost5.com |