Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle/RDBMS : no. of connections
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; Received on Thu Jan 13 2005 - 12:41:53 CST