My Oracle Support Banner

Oraclejdbcconnectionpoolstatistics.Getfcfprocessinginfo Returns Empty Output (Doc ID 1448239.1)

Last updated on OCTOBER 18, 2022

Applies to:

Universal Connection Pool - Version 11.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

OracleJDBCConnectionPoolStatistics.getFCFProcessingInfo does not give any output and returns an empty string after a node up/down event when using Universal Connection Pool 11.2.0.3.

The method should return output like the following example in :
Oracle® Universal Connection Pool for JDBC Developer's Guide
11g Release 2 (11.2)
9 Diagnosing a Connection Pool
Viewing RAC Statistics - Fast Connection Faiover Statistics
http://docs.oracle.com/cd/E11882_01/java.112/e12265/dgn_conpool.htm#CIHFBJFD


Oct 28, 2008 12:34:02 SUCCESS <Reason:planned> <Type:SERVICE_UP> \
      <Service:"svvc1"> <Instance:"inst1"> <Db:"db1"> \
      Connections:(Available=6 Affected=2 FailedToProcess=0 MarkedDown=2 Closed=2) \
      (Borrowed=6 Affected=2 FailedToProcess=0 MarkedDown=2 MarkedDeferredClose=0 Closed=2) \
      TornDown=2 MarkedToClose=2 Cardinality=2
    ...
    Oct 28, 2008 12:09:52 SUCCESS <Reason:unplanned> <Type:SERVICE_DOWN> \
      <Service:"svc1"> <Instance:"inst1"> <Db:"db1"> \
      Connections:(Available=6 Affected=2 FailedToProcess=0 MarkedDown=2 Closed=2) \
      (Borrowed=6 Affected=2 FailedToProcess=0 MarkedDown=2 MarkedDeferredClose=0 Closed=2)
    ...
    Oct 28, 2008 11:14:53 FAILURE <Type:HOST_DOWN> <Host:"host1"> \
      Connections:(Available=6 Affected=4 FailedToProcess=0 MarkedDown=4 Closed=4) \
      (Borrowed=6 Affected=4 FailedToProcess=0 MarkedDown=4 MarkedDeferredClose=0 Closed=4)



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.