Home » RDBMS Server » Server Administration » Queries on Number of users in a SID (merged)
Queries on Number of users in a SID (merged) [message #376709] Thu, 18 December 2008 06:00 Go to next message
Messages: 37
Registered: August 2008
Location: Gurgaon
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.
Re: Queries on Number of users in a SID (merged) [message #376726 is a reply to message #376709] Thu, 18 December 2008 06:40 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is none.
You have to connect to each database.

Previous Topic: GATHER_STATS_JOBS Broken
Next Topic: Strange database crash (no info. in alert log)
Goto Forum:

Current Time: Wed Aug 23 16:29:22 CDT 2017

Total time taken to generate the page: 0.05034 seconds