Re: Last SQL Statement Executed By User
- From: Juriy.Matey@xxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 31 Mar 2004 12:44:18 -0500
Dan,
all you need is V$SESSION view .
Here is an excerpt from documentation concerning fields from this view you
need to have a look at:
....
SQL_HASH_VALUE NUMBER Used with SQL_ADDRESS to identify the SQL
statement that is currently being executed
PREV_HASH_VALUE NUMBER Used with SQL_HASH_VALUE to identify the
last SQL statement executed
Regards,
Juriy Matey
Dan Looby <dan.looby@xxxxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
03/31/2004 11:01 AM
Please respond to oracle-l
To: oracle-l@xxxxxxxxxxxxx
cc:
Subject: Last SQL Statement Executed By User
I'm looking for a script that shows the last (if still available) SQL
statement executed by a user. I'm doing a presentation on VPD and want to
pull the SQL statement to show, hopefully, that the dynamic predicate was
added to the statement. Possible?
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
