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!

how to find sid,serial# for sql in v$sqlarea

ivwviMay 4 2009 — edited May 4 2009

Hi,

10gR2
in order to dig down the session which is running particular sql
say querying v$sqlarea and getting sql_id
now how to map it to v$session

This post has been answered by 677340 on May 4 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2009

Added on May 4 2009

#general-database-discussions

5 comments

22,677 views