SOA INFRA useful everyday queries


Very useful daily SOA 11g queries

soArchitecture

First of all, if you have not allready read the following links, this is the way to start…
Take a look:
https://forums.oracle.com/forums/thread.jspa?threadID=962459
The next blog holds all the information about the states and their meaning:
https://blogs.oracle.com/ateamsoab2b/entry/list_of_all_states_from

So, once you have read the above, you can easily understand the rest:

* Find running instances of a single composite

* Count Instances that have run for a specific composite in a single period

* Count All Instances by state in human readable format.

* Count All Instances by state in human readable format, group by composite.

* Count all orchestration processes that comes from mediator

* Query to find the execution time of BPEL instances

* Query to find the execution time of BPEL instances – Extend your search query to find the parent that has initialized the composite(very usefull!)

* Query to find the execution time of BPEL instances from VIEW…

View original post 81 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s