-- Version Info
RDBMS Version : 19c
OS : Oracle Linux
I have a production DB where several client servers are facing frequent timeouts.
In MOS, for various applications, I can see ENABLE=BROKEN parameter is added in the TNS entry at the client side to fix timeout issues.
KNF_DB =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL=TCP)(HOST=abc-scan.domain.net)(PORT=1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME=knfs.domain.net)
)
)
But, ENABLE parameter seems to be undocumented.
According to few links from google, ENABLE=BROKEN set in client's tnsnames.ora will send dummy packets from client to DB server to keep the connection alive.
But, some other links say, ENABLE=BROKEN will enable the client to detect the dead connections. Lets say this is true and a dead connection is detected by the client. So, now what will the client do ?
Which one is correct ? Is ENABLE=BROKEN parameter there to detect dead connections or to send dummy packets ?