What user2 did

Hi,

I'm under user1, i want to know what user2 did ---- eg, what select statment or other commands user2 did or is doing? What is the sqlcommand should i use?

Thanks

If you have enough privilege, run this SQL statement:

select SE.username, SE.status, SA.sql_text
from v$session SE, v$sqlarea SA
where SE.sql_address = SA.address;

Enjoy it!