|
|
|
|
|
|
| Re: Finding the sql statements executed in a session [message #370787 is a reply to message #370771] |
Tue, 08 February 2000 06:20  |
Thierry Van der Auwera
Messages: 44
Registered: January 2000
|
Member |
|
|
Hallo,
Yes this contains all the commandos for all the users,
but you can select it also for one userid.
Try following sql, you only have to set the username (in uppercase)
so alter 'THE_USER_NAME' to a the username you want.
Note: this is not session dependent, but user dependent.
SELECT *
FROM sys.v_$sqlarea
WHERE parsing_user_id = (SELECT DISTINCT user#
FROM sys.v_$session
WHERE username = 'THE_USER_NAME');
Hope this helps you.
Greetings,
Thierry.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
