Oracle Database
--
Questions
--
Followers
Top Experts
Oracle Enterprise Manager: What do 'Other' and 'Concurrency' mean?
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.
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.
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Hi,
EM has multiple monitoring metrics which it gathers from the running database and then in order to have more clear view of the database they are grouped together. For example, the "Concurency" metrics group is sum of times the database handles the locks, pins and any other metrics which relates to sharing of same resource i.e. to concurrent wait on resource.
If you click on the Concurrency ( colored in dark red) you will then get more detail view and based on that view you can troubleshoot your database. Based on your mentioning that you have MV which are being build every two hours that can be the issue since the database must wait for the data to be written in order to server the newly written data to other user. If you post the screenshot of concurrency view i can give you more helpful answer this is just pure guessing.
The Other category hold basically any metric that is not listed in any of major groups. Any advice on why other is showing is based on pure guessing.
EM has multiple monitoring metrics which it gathers from the running database and then in order to have more clear view of the database they are grouped together. For example, the "Concurency" metrics group is sum of times the database handles the locks, pins and any other metrics which relates to sharing of same resource i.e. to concurrent wait on resource.
If you click on the Concurrency ( colored in dark red) you will then get more detail view and based on that view you can troubleshoot your database. Based on your mentioning that you have MV which are being build every two hours that can be the issue since the database must wait for the data to be written in order to server the newly written data to other user. If you post the screenshot of concurrency view i can give you more helpful answer this is just pure guessing.
The Other category hold basically any metric that is not listed in any of major groups. Any advice on why other is showing is based on pure guessing.
Thanks for the feedback. Unfortunately I am not the DBA and am not allowed access to Oracle Enterprise Manager. I have limited access to DBA's for short periods of time. Our DBA's do not appear to be thoroughly knowledgeable about OEM's capabilities so I am going to have to study it up myself and then have them bring it up and walk them through it.
I'm thinking now that providing them a bunch of V$ dynamic view queries that they can run while I execute my queries will be more useful as all of the details will be there and there will be no need for me to search through the OEM interface to get ambiguous answers.
I'm thinking now that providing them a bunch of V$ dynamic view queries that they can run while I execute my queries will be more useful as all of the details will be there and there will be no need for me to search through the OEM interface to get ambiguous answers.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
It seems OEM is a dead end. If I need to spend time looking into this further it is best to spend that time better understanding the V$ views rather than OEM.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Oracle Database
--
Questions
--
Followers
Top Experts
Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.