SOA Infra Sql Queries 11g
We sometime face issue in environment wherein few instances takes more time to completed.
We need identify from SOA Infra DB which instances takes more than 10 seconds to completed during specific time period.
1) Can someone provide any query to identify instances which took more than 10 seconds to complete. (either from cube_instance or composite_instance table)
2) Sometimes there are performance issues from DB side and as per our DBA it occured as high transactions came from soa application . How can i gather data from db to confirm if high number of transactions occured or not