LOGON TRIGGER AND JDBC CONNECTION POOLING

I am using oracle 10.1.0.3 on Windows 2000 and JDK 1.4.2_06.

We have a packaged application which uses JDBC connection pool. I want to enable Oracle's tracing using logon trigger.

Let use assume there are maximum of 5 connections in connection pool.

1. Will logon trigger be invoked a maximum of 5 times (when database is up) or each time when getConnection is called.
2. Will there be a maximum of 5 sessions shown in v$session for connection pool (5 connections in connection pool) or a separate session is created, each time a getConnection call from Connection Pool is done nad connection used.

I will like to use dbms_monitor.set_clienf_identifier to distinguish different sessions.

Thanks Received on Sun Sep 11 2005 - 10:54:54 CDT