Although I don't use "Tomcat", I would imagine that there is probably a monitoring (or management) application (or utility or tool) that would provide you with this information. Have you tried asking in "Tomcat" related forums?
Good Luck, Avi.
Joined: Jan 28, 2004
About the v$session (although this isnt related to JDBC anymore), is it available to SYS only? How can I grant its SELECT privilege to other people?
Alec, An excerpt from Oracle Database Reference (chapter on dynamic performance views):
The catalog.sql script contains definitions of the views and public synonyms for the dynamic performance views. You must run catalog.sql to create these views and synonyms. After installation, only username SYS or anyone with SYSDBA role has access to the dynamic performance tables.
I believe the "catalog.sql" script is usually run as part of the installation process -- so you shouldn't need to run it.
In order to grant access, use the "GRANT" (SQL) statement -- but either as the SYS user, or some other user that has the SYSDBA role. See the Oracle SQL Reference for more details, but it should be something like:
But please verify that with the documentation -- I am only going from memory.
Good Luck, Avi. [ April 06, 2005: Message edited by: Avi Abrami ]