Topic: Database Administration >> Finding users in database
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Finding users in database |
| rsreddy28 |
Posted: May 23, 2007 11:13:20 AM |
Total Post: 35
Joined: Mar, 2007
|
Hello All,
I was asked in an interview " how do we find which users is connected to which database at the OS level and which user is doing what action."
Can somebody help me in that plz.
bYe,
Raj |
|
|
 beefcake |
| Posted: May 24, 2007 12:41:40 AM |  |
|
Total Post: 9
Joined: May, 2007
|
Hi Raj,
it is not possible to do that.
On UNIX we can see the process and know the process id for the users, but there's no possible way to know what the user are doing.
On Windows, because it is thread based OS, we can only see one oracle.exe process in task manager. There is process monitor tool to "see" the contents of the thread but like on UNIX it is not possible to know each user action through OS.
|
|
|
|
|
| Ahmed |
| Posted: Jul 11, 2007 04:42:56 AM | |
|
Total Post: 13
Joined: Mar, 2006
|
to know what sql a user is running now ,you can check the V$ACCESS dynamic view or you can use any 3rd party tool just like TOAD
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
