Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sessions based on sql id

938688Aug 31 2012 — edited Sep 3 2012

Hi,

One of our DB server is high on CPU utilization, as per the AWR we found couple of queries are running many times and taking huge CPU, hence we need to know from which user these queries are runnings.
can someone help me to find the session information as per the sql id?

Thanks,
Ramesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2012

Added on Aug 31 2012

#general-database-discussions

9 comments

1,774 views