from dify_date - eation_date 86400extract(hour from dify_date - from dify_date - eation_date 60extract(second from dify_date - eation_date) duration_in_second from cube_instance cube, composite_instance cmpinst where AND mposite_name'composite_name' and mponent_name'component_name' AND ATE 4 AND. When state4 then 'closed AND pending'. When state5 then 'closed AND completed'. When state9 then 'closed AND stale'. This web requires cookies to work correctly. If you do not get treatment, you might your.
Select * from select composite_name compositename, PST_ID begin_time, modify_date END_time, (extract(day from modify_date - creation_date 86400 extract(hour from modify_date - creation_date 3600 extract(minute from modify_date - creation_date 60 extract(second from modify_date - creation_date) duration_in_second,.* from cube_instance A where state 5 and creation_date between TO_date. Title) from composite_instance_fault f,composite_instance co where ID and mposite_DN'composite_DN' and eated_time TO_date 08:00:00 'yyyy-MM-DD HH24:Mi:SS * time outs select EXP_date from work_item where cikey Find time outs that did not fire up select * from work_item where creation_date between TO_date 16:00:00 'yyyy-MM-DD HH24:Mi:SS and TO_date. Created_time between TO_date 08:00:00 'yyyy-MM-DD HH24:Mi:SS and TO_date 18:00:00 'yyyy-MM-DD HH24:Mi:SS group by source_name * Query to find the execution time of bpel instances. Help me enable cookies on my browser. If you are currently using a private or an anonymous browser window, the cookies may be disabled as a part of this feature. When state1 then 'open AND running'. Take a look: the next blog holds all the information about the states and their meaning: so, once you have read the above, you can easily understand the rest: (ps: for 12c please check this. AND composite_name IN (composite_name order BY desc * Query to find the execution time of bpel instances Extend your search query to find the parent that has initialized the composite(very usefull!) select from cube_instance cu, ( select cmpinst. I have already enabled the cookies, show me the web. When state7 then 'closed AND cancelled'. SOA infra usefull everyday queries 12C ) * Find running instances of a single composite.