| List of OS and Oracle Users [message #73419] |
Wed, 21 April 2004 21:34  |
Sashi
Messages: 22
Registered: January 2004
|
Junior Member |
|
|
Hi All,
How can I get the List of Oracle Users accessing a particular table at a parituclar instance of time
For eg:
1) I want to see all the OS users accessing table "X" in a schema
2) I also want to list all the Oracle users of a Databse accessing table "X".
I'm able to see the list of all OS user sessions of a schema but not able to see the table name...is there any col as such to hold the "SQl body" of each session .
I checked V$session table but I didnt get the req info.
Any help....
|
|
|
|
|
|
| Re: List of OS and Oracle Users [message #73421 is a reply to message #73420] |
Wed, 21 April 2004 22:44  |
Sashi
Messages: 22
Registered: January 2004
|
Junior Member |
|
|
Thanks Chnadu for the info. But anyways, I cud get the req info for my actual requirement.
My actual prob was: Table had a Dead Lock and I wanted to list all the users accessing this table.
I cud download this query from ORAFAQ website.
Thanks once again .
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
