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!

Sql for top sql

587557Jul 30 2007 — edited Jul 31 2007

Dear DBAs

Application team has asked me to provide TOP Sql statements in testing database which can help them to improve code. Developer gave OEM top sql example from his last job.

Currently I do not have OEM installed. I am on 10.2.0.1.0 . I was thinking
to create a job to run sql and email everyday.

What sql can I use to generate that report ? What does OEM reports on when it show TOP Sql ?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 28 2007

Added on Jul 30 2007

#general-database-discussions

10 comments

574 views