Re: Oracle/RDBMS : no. of connections

From: MadhuS <madhu_dba-publicdonotspam_at_yahoo.com>
Date: 13 Jan 2005 13:11:34 -0800
Message-ID: <1105650694.399878.184920@f14g2000cwb.googlegroups.com>

cartwrij wrote:
> Eitan wrote:
> > Hello,
> >
> > How can I find the no. of oppened connections to Oracle ?
> > (Suppose I forgot to close a connection by mistake - how can I know
> the
> > actual no. of oppened connections).
> >
> > I need a solution for Oracle 8i, and also for rdbms, please.
> > Thanks :)
>
> select * from v$sessions;

You can also look for sessions_current in v$licenses.

-MadhuS Received on Thu Jan 13 2005 - 15:11:34 CST