Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: number of users using oracle

Re: number of users using oracle

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 30 Nov 1999 09:31:00 +0100
Message-ID: <8201ve$2facu$1@oceanite.cybercable.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US