Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: number of users using oracle
To get all user sessions:
select count(*) from v$session where type='USER';
or
select username from v$session where type='USER';
The number of Oracle background processes depends on parameters of the init.ora file (snapshot_refresh_process, job_queue_processes, ...)
--
Have a nice day
Michel
<kaprino_at_my-deja.com> a écrit dans le message : 81v57h$cqt$1_at_nnrp1.deja.com...
> Just wanted to know if there was a simple command in oracle to see how
> many users are accessing or logged into the database, similiar to
> sybase's sp_who command. If not, how or what would I have to do to
> find out?
>
> Thanks
>
> Kaprino
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 30 1999 - 02:31:00 CST