We are using Oracle Enterprise Manager on an Oracle 11g database to identify bottlenecks in the execution of queries. We have a query that can take as long as 2 minutes to execute the first time, and then around a second if executed again.
The Oracle Enterprise Manager has a multi-colored bar detailing how much time is taken up for different issues. The longest parts of the bar are labeled 'Other' and 'Concurrency'.
Any ideas what could be included in Other and/or Concurrency? I'm thinking that part of Other could be parsing of the query, but was wondering if there were other issues that could be causing the time sink? All of the objects in our database are Materialized Views from another database on the same server. These Materialized Views are updated about once every two hours. I'm wondering if the Concurrency issues are related to the database waiting until the MV's are synced.
I've tried researching this, but one article leads to ten more, which each lead to ten more none of which provide much clarity.