How to know which user or sessions are accessing a particular table in Oracle 10g?
Hi:
Does anyone know how to write a script to report current users (e.g: session id, os_name, logon_time) that are accessing (select/insert/delete/update) a particular database table?
we are in Oracle 10.2.0.5 and recently my developers are asking me this. I used to have a script checking with v$access, as I remember but not sure, because I forgot what 'type' means in below v$access and it takes very long in returning any rows when I tested, it runs like hanging!
SQL> desc v$access
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
OWNER VARCHAR2(64)
Does anyone know how to write a script to report current users (e.g: session id, os_name, logon_time) that are accessing (select/insert/delete/update) a particular database table?
we are in Oracle 10.2.0.5 and recently my developers are asking me this. I used to have a script checking with v$access, as I remember but not sure, because I forgot what 'type' means in below v$access and it takes very long in returning any rows when I tested, it runs like hanging!
SQL> desc v$access
Name Null? Type
----------------------------------------- -------- ----------------------------
SID NUMBER
OWNER VARCHAR2(64)
0