USING OEM to find the cause of Slow runign query

what are the steps that I need to take USING OEM to diagnose and solve the slow running SQL query?

Say a query started taking way too long to complete.
to handle the issue I start OEM now
1st step
2nd step....
.....
.....
.......
taazAsked:
Who is Participating?
 
shomilbConnect With a Mentor Commented:
Login to OEM
Select target database.
Goto Performance tab.
Under Additional Monitoring Links: Goto Search Sessions.
Search the concerned session using SID or select other options from drop down.
In the Session Details page you will all the more information.
You can look into Wait events and explore further.
There is another useful tab SQL Monitoring, which tells the actual status of the running query.
0
 
Swadhin RayConnect With a Mentor Senior Technical Engineer Commented:
Please check this link for how to analyzer in Oracle Database 11g along with the steps :

http://www.oracle-base.com/articles/11g/sql-performance-analyzer-11gr1.php
0
 
Geert GConnect With a Mentor Oracle dbaCommented:
oem will not solve your problem
>> you can create indexes via oem

easiest is to check the execution plan:

to generate the explain plan
explain plan for
select * from .... ;

to view the explain plan
select *
from table(DBMS_XPLAN.DISPLAY('PLAN_TABLE'));

more info:
http://www.oracle-base.com/articles/9i/dbms_xplan.php

based on the execution plan evaluation of a query can be done
0
 
taazAuthor Commented:
Thanks, The answers really helped me to great extent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.