COMPOSITE_INSTANCE

SOA prcess 상태 모니터링

* COMPOSITE_INSTANCE

SELECT COUNT(*) "No. of instance(s)",

state "State",

DECODE(state, '0', 'STATE_INITIATED', '1', 'STATE_OPEN_RUNNING', '2', 'STATE_OPEN_SUSPENDED', '3', 'STATE_OPEN_FAUKTED', '4', 'STATE_CLOSED_PENDING_CANCEL', '5', 'STATE_CLOSED_COMPLETED', '6', 'STATE_CLOSED_FAULTED', '7', 'STATE_CLOSED_CANCELLED', '8', 'STATE_CLOSED_ABORTED', '9', 'STATE_CLOSED_STALE', '10', 'STATE_CLOSED_ROLLED_BACK') "Description"

FROM cube_instance

GROUP BY state

* MEDIATOR_INSTANCE

SELECT COUNT(*) "No. of instance(s)",

component_state "State",

DECODE(COMPONENT_STATE, '0', 'No faults might be running', '1', 'aborted by user', '2', 'faulted(non-recoverable'), '3', 'faulted or aborted', '4', 'recovery required', '5', 'recovery required or aborted', '6', 'recovery required or faulted', '7', 'recovery required or faulted or aborted', '8', 'RUNNING', '9', 'RUNNING', '10', 'RUNNING) "Description"

FROM mediator_instance

GROUP BY component_state

 

 

※ 참고사이트 : http://beatechnologies.wordpress.com/2011/08/04/querying-composite-instance-states-in-soa-infra-dehydration-store-for-oracle-soa-suite-11g-processes/