Skip to main content

Connection Validation too expensive

3 replies [Last post]
omerlin
Offline
Joined: 2007-09-26

Hello,

With use an Oracle Database and have executed some performance bench on Glassfish.
We saw that the Connection Validation cost on the Database server is 10% of the total CPU ! (select * from dual; statement)

The problem is apparently that we can't limit the number of connection validation on the Oracle Pool - no interval setting and no dedicated thread to the connection validation treatment.

Does someone has found a solution (a custom development or a workaround) ? Or is there some official enhancement on this point ?
This is really sad to have to remove this functionality - normally re"quired in production

rgds,

Olivier

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
sm157516
Offline
Joined: 2005-03-28

Could you try the same after setting "fail-all-connections" to true?

sm157516
Offline
Joined: 2005-03-28

Also, to minimise the number of validation calls, the attribute validate-atmost-once-period-in-seconds could be set to an appropriate value, so that within this interval, a connection is validated atmost once.

omerlin
Offline
Joined: 2007-09-26

Well done !!
This parameters work eactly has expected.
The overhead has disapeared .

Many thanks,
Olivier