Home » RDBMS Server » Server Administration » to find the last executed statement
to find the last executed statement [message #329616] Thu, 26 June 2008 00:50 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


HI,

I like to know the last executed statement of a user. How can i get this.

For example, i have logged on using dba_user and another person is logged on using test_user. dba_user has dba privileges. Whether can i know the last statement executed by test_user.


thanks in Advance,

Seenu
Re: to find the last executed statement [message #329618 is a reply to message #329616] Thu, 26 June 2008 00:53 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>How can i get this.
without prior planning, you can not.

Re: to find the last executed statement [message #329625 is a reply to message #329616] Thu, 26 June 2008 01:17 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The following column of v$session (joining with v$sql) may help (but not sure, depending on the case):
SQL_ADDRESS
SQL_HASH_VALUE
SQL_ID
SQL_CHILD_NUMBER
PREV_SQL_ADDR
PREV_HASH_VALUE
PREV_SQL_ID
PREV_CHILD_NUMBER

Regards
Michel
Previous Topic: how to find how many connections are opened by each session in DB
Next Topic: 16k Blocksize
Goto Forum:
  


Current Time: Sat Dec 10 22:29:39 CST 2016

Total time taken to generate the page: 0.10553 seconds