If you have a large number of composite instances present for a single or multiple composites the Enterprise Manager will not be a very ideal place to look at if we want to know the states of these instances.
We can however connect directly to the SOA_INFRA schema for our Oracle SOA Suite installation to execute a few scripts to view instance states of various composites.
Here are the database scripts available to find composite instances in various states in the CUBE_INSTANCE table.
The table below shows the various State Value for composite instances in the CUBE_INSTANCE table of the SOA_INFRA schema in the dehydration store.
|STATE VALUE||STATE||STATE MEANING|
State value for an instance that has just been created. The instance will only have this value as its state after it has been created by the process domain.
|1||OPEN AND RUNNING||
State value for an…
View original post 406 more words