My Oracle Support Banner

Disconnect is Very Slow when using GSM to Access the Pool Database (Doc ID 2614092.1)

Last updated on MAY 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Goal

Summary of Issue
-------------------------
Connecting from ANY client (or server) using the GSM listener, the connection is fast but the DISCONNECT is VERY SLOW (5 seconds or more). However,
connecting from ANY client (or server) using either the SCAN listener or Local listener with VIP, both the connection and disconnect are fast (msecs).


- Fast disconnect -->
339169 14:46:19.525050 read(0, "exit\n", 1024) = 5 <1.302053> -------> 1.3 msecs to "read" the exit
339169 14:46:20.827241 epoll_ctl(10, EPOLL_CTL_DEL, 9, {0, {u32=24200320, u64=24200320}}) = 0 <0.000015>
339169 14:46:20.827283 fcntl(9, F_GETFL) = 0x802 (flags O_RDWR|O_NONBLOCK) <0.000011>
339169 14:46:20.827314 fcntl(9, F_SETFL, O_RDWR) = 0 <0.000011>

- Slow disconnect -->
13689 14:53:41.589756 read(0, "exit\n", 1024) = 5 <316.659580> -------> 5 seconds to "read" the exit
13689 14:58:58.249567 epoll_ctl(9, EPOLL_CTL_DEL, 10, {0, {u32=39769344, u64=39769344}}) = 0 <0.000024>
13689 14:58:58.249660 fcntl(10, F_GETFL) = 0x802 (flags O_RDWR|O_NONBLOCK) <0.000012>
13689 14:58:58.249712 fcntl(10, F_SETFL, O_RDWR) = 0 <0.000014>

You could set the following environment variables to get ONS client tracing.

export ORACLE_ONS_DEBUG=true
export ORACLE_ONS_LOGFILE=/tmp/onsdebug.trc

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.