Database Administration (MOSC)

MOSC Banner

The listener gets slower.

edited Aug 26, 2021 7:41PM in Database Administration (MOSC) 9 commentsAnswered

Environment:

AIX: 7.2 (7200-04-01_1939)

RDBMS: Database Release Update 19.7.0.0.200414

Symptoms:

The connection to the database is delayed. 

On the server itself tnsping (loop-back test) takes 10000-15000 msec.

After listener restarting, the problem disappears for a while (2-3 day), loop-back test takes 0-10 msec as normal. Sessions count remains approximately the same as before listener restarted. At the OS level (netstat) TIME_WAIT, ESTABLISHED count remains the same too.

Question:

What could be the reason?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center