Hey Cliff and John,
on Sept 22, 2010 you posted about issues you were having with getting
Oracle DRCP working using the ora_drcp_class. I am running into
similar issues and was wondering if you got DRCP to work and have it
share the connection. We are using oracle 11.2.0.2 and I have perl
v5.8.8, DBI 1.602 and DBD::Oracle 1.28.
here is my Tnsnames and basic connect string(DRCP is setup at the Listener):
$sid = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = $host)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME = $service)(SERVER=POOLED)))
$self->{dbh} = DBI->connect("dbi:Oracle:$config->{sid}",
$config->{user}, $config->{pass},
{ AutoCommit => 0, ora_drcp_class =>
"feedAutomation" } );
yet I am not seeing the $user.feedAutomation CClass and I see no
increase in Num_hits for any class that is there:
1* select * from v$cpool_cc_stats
CCLASS_NAME
--------------------------------------------------------------------------------
NUM_REQUESTS NUM_HITS NUM_MISSES NUM_WAITS WAIT_TIME CLIENT_REQ_TIMEOUTS
------------ ---------- ---------- ---------- ---------- -------------------
NUM_AUTHENTICATIONS
-------------------
$user.SHARED
1346245 0 1346245 61582 0 0
1346245
Everything runs fine, it just doesn't share the connections and
increase Num_hits.
any thoughts?
thanks!
-Rob
