Database Networking (MOSC)

MOSC Banner

Connection Slow

edited Sep 25, 2015 2:51PM in Database Networking (MOSC) 2 commentsAnswered ✓

I setup a new database and for some reason the connection is slow.


It works fine if connecting locally (sqlplus / as sysdba).

But when connecting like sqlplus user@test it takes a couple of seconds to connect.

I found another post that has a similar problem and it references Doc ID 1359821.1

With that I was able to determine that the server process is the issue. There is a delay between the sntpcall and nsbequeath (two seconds).

I ran the following command to determine the issue: awk '/fork|NSE=12586/' ora_8857_47126223842032.trc

Here's the result:

2015-09-23 08:18:03.790939 : sntpcall:detaching from parent with additional fork

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