Skip to Main Content
Forums

SQL & PL/SQL

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!

Join V$SQLAREA and V$Session

786725Jul 22 2010 — edited Jul 22 2010
hi all,

which column i need to use to join V$session and V$sqlarea?

My main aim is to find top 5 queries with most disk_reads and generate a report containing relevant information.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2010
Added on Jul 22 2010
#session
2 comments
2,247 views