Page 1 of 1
How can we check User activity on Database
Posted: Fri Jun 15, 2007 7:15 am
by zeenat khan
I want to create / maintain transaction history of any user connected to Database by Toad / SQL Developer etc.
Is it possible and how can I do this.
Posted: Thu Sep 27, 2007 4:36 am
by wizard786
Hi Zeenat,
Find the SID of the sessions working from TOAD. Then you can set trace in that session and find what they have been doing.
cheers,
Posted: Thu Sep 27, 2007 5:48 am
by anu_uma
Hi,
Can u please give some more in detail... if u can pls give the query and what should we do to trace an user
Posted: Fri Sep 28, 2007 2:26 am
by Rizwan.Cheema
Hi Zeenat,
You can get information through V$SESSION
select STATUS, SERVER, SCHEMANAME, OSUSER, PROCESS, MACHINE, TERMINAL, PROGRAM, TYPE, SQL_ADDRESS from v$session
Thanks and Regards
Rizwan Cheema