Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> concurrent connection tracking

concurrent connection tracking

From: <Lisa_Koivu_at_gelco.com>
Date: Fri, 9 Jun 2000 06:30:46 -0500
Message-Id: <10523.108370@fatcity.com>


Does anyone know of a way to track the number of concurrent connections to a database?
For some reason the License High Water Mark in the alert log isn't good enough - because it tells the truth: at one point one of our databases had a bunch of runaway processes and there were 591 concurrent connections. My boss doesn't think that's good enough.

I can't think of a way other than auditing and/or enabling some sort of sqlnet tracing (please no...)
or my usual response: write a ksh script to do it for me. I'm thinking the latter will do fine, but if there is something in Oracle I am not aware of I'd like to hear of it.

Thanks
Lisa
*O*mnipotent *C*at *P*erson Received on Fri Jun 09 2000 - 06:30:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US