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

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
>How can i get this.
without prior planning, you can not.

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 22:47:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.