Re: Oracle database concurrent connections
From: Bhooshan Prabhu <bhooshan.s.prabhu_at_orbitech.co.in>
Date: 19 Jul 2002 07:03:32 -0700
Message-ID: <16584988.0207190603.6dcbdd17_at_posting.google.com>
> 2. Where those connections come from?
Date: 19 Jul 2002 07:03:32 -0700
Message-ID: <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!
Received on Fri Jul 19 2002 - 16:03:32 CEST