The database connection not getting released over dblink
Hi All,
The connections are getting established for a process from database A to database B over dblink.
However when the process gets completed and the sessions from database A are exited we are still observing the sessions running on database B in active state.
These sessions have a wait event of 'TCP Socket (KGAS)' and do not execute any queries.
The last executed sql statement on these sessions is as follows:
=============================================================================
SELECT HOST,
LOWER_PORT,
UPPER_PORT,
STATUS
FROM (SELECT *
FROM ( SELECT P.*,
DBMS_NETWORK_ACL_UTILITY.CONTAINS_HOST (:1, HOST)
PRECEDENCE
FROM SYS.USER_NETWORK_ACL_PRIVILEGES P