oraman wrote:does application utilize Connection Pooling?
I get regularely this error:
oracle TNS-12602: TNS: Connection Pooling limit reached
however according to this view there is no limit reached:
select * from v$resource_limit where resource_name in ('processes','sessions');
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
processes 94 138 600 600
sessions 107 220 1008 1008
is my perception somehow wrong?
12602, 00000, "TNS: Connection Pooling limit reached" // *Cause: The operation failed because maximum active current connections has // been reached. It may not be a real error when the Connection // Pooling feature is enabled. It is possible that the application // later reissues the operation and successfully grabs the connection // pool slot and proceeds. // *Action: This is an internal error. Enable tracing and attempt to repeat the // error. If it occurs again, contact Oracle Customer // Support.