RMS Batch - Trace session
PT : RMS - Trace sessao ( Logon Trigger ) EN : RMS - Trace Session ( Logon Trigger )
Posts
Showing posts from August, 2014
DB - Monitor, Locks
- Get link
- Other Apps
E a tal query que nao termina And about that query that never ends ... -- -- General -- set lines 240 col message form a100 col opname form a50 select * from ( select round(l.sofar/l.totalwork*100,2) as complete, --l.* l.sid, --l.opname, l.message, l.start_time, l.time_remaining/60 "minuts remaining", l.elapsed_seconds from gv$session_longops l where totalwork !=0 ) where complete < 100; -- -- RMAN Specific -- select sid, serial#,opname, context, sofar, totalwork, round(sofar/totalwork*100,2) "%_complete" from v$session_longops where lower(opname) like 'rman%' and opname not like '%aggregate%' and totalwork != 0 and sofar <> totalwork; select to_char(start_time,'dd-mon-yy hh24:mi') "backup started", opname, sofar, totalwork, elapsed_seconds/60 "elapse (min)", round(sofar/totalwork*100,2) "complete%" from v$session_longops where lower(opname) like 'rman
RIB - JMS AQ
- Get link
- Other Apps
English Version Neste post partilho algumas queries que usei para monitorizar o processamento de mensagens no RIB. -- find all items queues SQL> select * from user_queues where queue_type = 'NORMAL_QUEUE' and name like '%ITEM%' --- find all items to process SQL> select * from ETITEMSTLFROMRIBTABLE -- queue subscribers SQL> select * from AQ$_ETITEMSTLFROMRIBTABLE_S -- queue historic SQL> select * from AQ$_ETITEMSTLFROMRIBTABLE_H where msgid = 'FE4C339218D830B1E0440024813309CD' --- find all tables/queue tables SQL> select * from dba_tables where table_name like '%ETITEMSTLFROMRIB%' Testar Integracao - RMS > WMS Uma forma facil de testar a integracao (RIB) apos adicionar um novo warehouse (WMS), e actualizar um Item no RMS e validar se as alteracoes estao a ser transmitidas ao WMS, no exemplo seguinte mostro como fazer isso, e os tabelas/queues envolvidas. Item : 101715654 -- RMS DB SQL> select item, item_desc from item_master wher