Keep connection alive help

[geraldwinslow]

Folks,

I'm wanting to keep an Oracle connection alive through a firewall. My solution is to periodically (every few minutes) query the database in background with "SELECT 1 FROM dual". Does this sound like a good idea, or is there some better way to keep a connection alive?

Thanks!
Gerald Winslow

 

[Marco Kalter]

I assume your firewall drops connections after a certain idle time? If so, this should work. Alternatively there may be some TCP KeepAlive functionality to solve this.

------------------
Marco Kalter
Allround Automations

 

[SvenHeuer]

Be aware. I had a cisco-router which needed not only just traffic every minute. There had to be also a minimum of traffic per sec. (1k/s)

Greetings
Sven