slowness in making and closing connections

From: Enivaldo Freire do O' <enivaldo_at_my-deja.com>
Date: Fri, 09 Feb 2001 14:58:32 GMT
Message-ID: <9610ii$vun$1@nnrp1.deja.com>

Hi,

I have a problem with a 7.3.3 Oracle on Dec-Unix. When using sqlplus locally (no listener up, only ORACLE_SID set), the sqlplus time (cpu + system) to get the prompt is very big (50 secs), about the same of the dedicated process started to serve sqlplus. The queries are returned very fast but when quitting the same problem occurs (more 50 secs for both processes).

This didn't happen before, only from a few days ago, without notice. It also happens for a sid1 database resident on the same server.

Help needed!

Enivaldo

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 09 2001 - 08:58:32 CST