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!

TOP 10 SQL QUERIES

561232Dec 22 2008 — edited Dec 22 2008

Hi,

How can i find the top 10 sql queries which consuming high IO, CPU's. in oracle db.
I am doing in one way that by using TOP command trying to get PID's then i am getting the sql query by applying the hash value in v$sqlarea.

Is there any way to get directly high consumed IO and CPU's with out seeing PID's in TOP command.

Thansk

This post has been answered by alanm on Dec 22 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2009

Added on Dec 22 2008

#general-database-discussions

4 comments

12,843 views