Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Number of users in Oracle?
Do you run a listener? Can users connect to the database through SQLNET in a client/server mode? Did all your users log off cleanly without leaving anything behind?
The V$SESSION holds the names of the sessions. You could look at it more closely to see where your session count is coming from.
column timex format a16
select a.username, to_char(b.timestamp, 'yymmdd hh24:mi:ss') timex,
a.audsid
from v$session a, dba_audit_session b
where a.audsid = b.sessionid
and a.audsid <> 0 ;
Maybe that will give you the extra information you need to see what's going on.
Marek
David E. Daniel wrote:
>
> I recently download this script. Quite possibly from one of the ORacle
> news groups, perhaps here. It is as follows:
>
> select count (*)
> from v$session
> where username is not null;
>
> This script was labeled as one that would tell me how many users I
> currently have at any given time. It appears that I am currently over
> my limit on users because the count returned is 23. This however is not
> the case. I currently have only 11 users logged on, no batch processes
> running. I have 12 total licenses and I really would like to manage
> within that range.
>
> What is v$session supposed to show me. Is it current count, a
> cumulative total, or what?
>
> Is there a better way to check the total number of users?
>
> -David E. Daniel
> Western Michigan University
Received on Fri Dec 06 1996 - 00:00:00 CST