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!

Find out queries running in Database at somepoint of time

794905Mar 16 2011 — edited Mar 16 2011

Hi All,

We have oracle 10g database running on solaris platform.Actually CPU utilization at specific point of time is very high.So I want to know all sql's running in Database at specific point of time.

Could you please help me out with the query to find out all sql's running at some point of time in database?

Thanks a lot

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2011

Added on Mar 16 2011

#general-database-discussions

7 comments

1,277 views