I am using weblogic JDBC datasource and my DB is oracle 10g,below is the configuration.

It used to work fine but suddenly it started giving problem,please see below exception.

Weblogic JDBC datasource,java.sql.SQLException: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool

<?xml version="1.0" encoding="UTF-8"?> <jdbc-data-source

xmlns="http://www.bea.com/ns/weblogic/90" xmlns:sec="http://www.bea.com/ns/weblogic/90/security" xmlns:wls="http://www.bea.com/ns/weblogic/90/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.bea.com/ns/weblogic/920 http://www.bea.com/ns/weblogic/920.xsd"> XL-Reference-DS
jdbc:oracle:oci:@abc.COM oracle.jdbc.driver.OracleDriver user DEV_260908 password password dll ocijdbc10 protocol oci oracle.jdbc.V8Compatible true baseDriverClass oracle.jdbc.driver.OracleDriver
1 100 1 true SQL SELECT 1 FROM DUAL

DataJndi OnePhaseCommit

This exception is coming on dev environment where connected user is only one.

I know, this is related to pool max size but I also suspect this could be due to oracle,might be oracle isn't able to create connections.

below are my queries

1. Is there any debug/logging parameter to enable datasource logging,so that I can check no of connections acquired,released and unused in logs ?
2. How to check oracle connection limit for a particular user ?