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 a slow query

631607May 15 2008 — edited May 16 2008

Hi all,

I have two questions about the SQL tuning:

There are many open sessions for an Oracle database,
(1) How to find the session that runs a slow query?
(2) How to locate / find this slow query so that the query can be tuned?

Thanks a lot.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2008

Added on May 15 2008

#general-database-discussions

3 comments

1,135 views