Forum Stats

  • 3,741,183 Users
  • 2,248,384 Discussions
  • 7,861,667 Comments

Discussions

Lots of inactive sessions causing DB server outage

We've got a Oracle database with only one application as client. The app is connecting to DB through UCP with OCI driver. We have set all available paramenters in pool as follows:

             abandonedConnectionTimeout="60"

             inactiveConnectionTimeout="60"

            maxConnectionReuseTime="60"

            maxIdleTime="60"

Also we have configured sqlnet.ora configuration file with SQLNET.EXPIRE_TIME = 10 both server and client side and activated idle_time in profile as follows:

alter profile default limit idle_time 10;

After all of this setting, we still have connection issues because inactive sessions do not stop growing and, after some time, we need to restart applicacion to release datbase connections/sessions.


Datasource statistics does not show any problem (I migth be worng):

Statistics:
AvailableConnectionsCount=4,
BorrowedConnectionsCount=1,
TotalConnectionsCount=5,
ConnectionsCreatedCount=1496,
ConnectionsClosedCount=1491,
AbandonedConnectionsCount=0,
LabeledConnectionsCount=0,
PendingRequestsCount=0,
RemainingPoolCapacityCount=70,
PeakConnectionsCount=1,
PeakConnectionWaitTime=0,
AverageBorrowedConnectionsCount=1,
AverageConnectionWaitTime=0,
CumulativeConnectionBorrowedCount=22,
CumulativeConnectionReturnedCount=21,
CumulativeConnectionUseTime=400,
CumulativeConnectionWaitTime=0,
CumulativeSuccessfulConnectionWaitCount=22,
CumulativeSuccessfulConnectionWaitTime=0,
CumulativeFailedConnectionWaitCount=0,
CumulativeFailedConnectionWaitTime=0
SuccessfulAffinityBasedBorrowCount=0,
FailedAffinityBasedBorrowCount=0,
SuccessfulRCLBBasedBorrowCount=0,
FailedRCLBBasedBorrowCount=0,
ConnectionRepurposeCount=0,
(FCFProcessingInfo=)
(FCFProcessingInfoProcessedOnly=)


Why is UCP pool creating all that sessions and not clearing them? What else can we configure to avoid this from happening. Thanks.

Tagged:

Answers

Sign In or Register to comment.