| Queries on Number of users in a SID (merged) [message #376709] |
Thu, 18 December 2008 06:00  |
dhimanvipin
Messages: 37
Registered: August 2008
Location: Gurgaon
|
Member |
|
|
Hi All,
I don't know its better to place such queries here(Please let me know if this group is not for such discussions) but I have following queries
Suppose I have a oracle instalced and there are more than one SIDs there(eg- emqa80,emdbnew etc).
I want a SQL query which tells me all the user with corresponding SIDs(eg- if user vipin is in emqa80 it should show me the user as well their SIDs)
I also want to know how could I know about the # users in a SID.
Thanks in advance.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
