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!

Joining information in v$sql and v$session

Thomas MauchApr 2 2009 — edited Apr 7 2009
Hello

I know how to join v$sql and v$session for getting information about the currently executed statement. However I would like to get more historical information:

- I found an interesting query in v$sql. Is there a way to find out which session has executed this query as last?

- And the other way around: Is there a way to find out for an entry in v$session which was the query it executed as last?

Thanks,
Thomas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2009
Added on Apr 2 2009
4 comments
1,173 views