> I am not sure what the 'connection class' and NUM_HITS are? > > Can you give me an example of where you are getting these and how the DRCP > should connect. >
I'm looking at the Oracle view v$cpool_cc_stats, which has connection class statistics for the connection pool. (http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/dynviews_1082.htm) NUM_HITS - Total number of times a session that matches with the request was found in the pool. Basically, it never finds a match. Connection Class is synonymous with ora_drcp_class. Something that is not clear to me - does DBD::Oracle 1.25 DRCP work with Oracle 11.1? Our production server is running 11.1, and our test machine is 11.2. I have built DBI / DBD::Oracle on the test side using an 11.1 client. I was going to try using an 11.2 client this morning to see if that's the problem. Cliff