Re: Oracle database concurrent connections
Date: 21 Jul 2002 23:00:12 -0700
Message-ID: <6f77ff2a.0207212200.5455e9b2_at_posting.google.com>
bhooshan.s.prabhu_at_orbitech.co.in (Bhooshan Prabhu) wrote in message news:<16584988.0207190603.6dcbdd17_at_posting.google.com>...
> jingc3_at_yahoo.com wrote in message news:<acd69dfb.0207181231.22d50a38_at_posting.google.com>...
> > Hi there,
> >
> > Is there any way or any tool that I can find out:
> >
> > 1. How many concurrent connections are being used for an Oracle database?
>
> SELECT COUNT(*)
> FROM v$session
> WHERE osuser != 'oracle' //** To exclude oracle connections to database**/
> > 2. Where those connections come from?
>
> SELECT SID,USERNAME,OSUSER,MACHINE
> FROM v$session
> WHERE osuser != 'oracle' //** To exclude oracle connections to database**/
>
> >
> > Thanks!
Try Oracle session manager at http://www.wangz.net,it just what you need! Received on Mon Jul 22 2002 - 08:00:12 CEST