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 get the sql_id's for a particular sid?

939873May 26 2012 — edited May 27 2012

Hi,
I would like to know how to get the sqlid's that was executed by a single sid. If a sid runs 4 different sql the sqlid will change but the sid will be the same.
I can get the 4th sql id & the 3rd sql id by querying v$session.SQL_ID & v$session.PREV_SQL_ID. How to get the 1st & 2nd sqlid?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2012

Added on May 26 2012

#general-database-discussions

6 comments

4,998 views