How can we check User activity on Database

[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.

[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,

[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

[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