Oracle disconnect
Posted: Tue 14 Jun 2022 08:29
Hello,
I have an application that is pooling a table in oracle from delphi (odac) every second. After a time, in some cases 20 minutes in other 50 minutes, the procedure can't be executed due to the connection lose and this app should be running 24/7. To solve this situation every 10 minutes I disconnect from the ddbb and connect again. My questions are:
Is this something related to the session time in oracle or the ODAC component?
Which would be "the best way" to "keep alive" the connection?
Thanks in advance.
PD: I have seen many answers related to the orasession, reconections etc, but ...
I have an application that is pooling a table in oracle from delphi (odac) every second. After a time, in some cases 20 minutes in other 50 minutes, the procedure can't be executed due to the connection lose and this app should be running 24/7. To solve this situation every 10 minutes I disconnect from the ddbb and connect again. My questions are:
Is this something related to the session time in oracle or the ODAC component?
Which would be "the best way" to "keep alive" the connection?
Thanks in advance.
PD: I have seen many answers related to the orasession, reconections etc, but ...