http://livedocs.macromedia.com/jrun/4/JRun_Service_Pack_1_Guide/4relnotes9.h
tm#1177004
<http://livedocs.macromedia.com/jrun/4/JRun_Service_Pack_1_Guide/4relnotes9.
htm#1177004>
_____
From: Allen, Dave [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 5:54 PM
To: JRun-Talk
Subject: RE: # of Database connections open
Alex,
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]
