The following SQL will give you a tally of open sessions in Oracle. If
you are using a connection pool, you can set debug=true to get a tally
of connection pool objects in the log files. You can also set debug=true
in the connection string of some drivers (see the readme).
SELECT P.SPID, S.USERNAME, S.OSUSER, S.STATUS
FROM V$SESSION S, V$PROCESS P
WHERE S.PADDR = P.ADDR
ORDER BY S.USERNAME;
What driver do you use? Are you on JRun 4 Updater 2?
David Allen
Software Engineer
Airservices Australia
E-mail: [EMAIL PROTECTED]
-----Original Message-----
From: DeMarco, Alex [mailto:[EMAIL PROTECTED]
Sent: Thursday, 15 January 2004 8:21 AM
To: JRun-Talk
Subject: # of Database connections open
Is it possible for Jrun to log the tally of currently open Oracle
Databse connections? Is so how?
Thanks
- Alex
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
