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

Home -> Community -> Usenet -> c.d.o.server -> Re: Number of Oracle Connections

Re: Number of Oracle Connections

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 29 Aug 2000 21:12:57 +0800
Message-ID: <39ABB6D9.EE@yahoo.com> 






Catarina Reis wrote:


> 

> Hello!

> 

> Does anyone know how to check the number of concurrent connections

> opened in an Oracle DataBase?

> 

> Regards

> Catarina




A quickie is 'select count(*) from v$session where username is not null'



HTH


-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse


Received on Tue Aug 29 2000 - 08:12:57 CDT












Original text of this message













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