Re: Identifying Application Spawned Connections

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Fri, 3 Feb 2006 09:54:50 -0500
Message-ID: <11u6rkkbv6b4qae@corp.supernews.com>

"Michael42" <melliott42_at_yahoo.com> wrote in message news:1138976024.140447.251110_at_g47g2000cwa.googlegroups.com...
> Hello,
>
> On an Oracle 9i database running on Solaris 8 I need to identify how
> many connections are being created by some custom applications. I am
> doing this as we suspect yhey are not ideally managing database
> connections and as the DBA I need to prove the case before getting the
> vendor to make the required changes. Ugg.
>
> In OEM I can see all the connections but need to go a bit deeper.
> Perhaps this is a UNIX related question to as I may need to correlate
> PIDs to Oracle connections etc.
>
> What can you recommend?
>
>
> Thanks,
>
> Michael42
>

Look in v$session and check how many sessions you have for the same v$session.process

select osuser, program, count(*)
from v$session
group by process, osuser, program
having count(*)> 1

HTH Syltrem Received on Fri Feb 03 2006 - 08:54:50 CST