This query can be used to get session info as well as the current and previously cached SQL executed in a given session.  You will need to add a where clause relevant to what you are looking for.  I generally use the osuser or username values.

This information can also be obtained by a session trace, but if that is not an option this is a good place to start investigating.

Oracle doesn’t recommend joining system views because doing so does not guarantee read consistency.  However, I have not experienced any issues with this query.


Leave a Reply

Your email address will not be published. Required fields are marked *