Re: connection time issues

On Jul 25, 12:16 pm, Ben <bal..._at_comcast.net> wrote:
> I have two databases on the same unix box. AIX5L
>
> logging into instance #1 10.2.0.2 EntEd using 10.2.0.1 sqlplus windows
> cilent takes > 10 seconds.
>
> logging into instance #2 9.2.0.5 EntEd using 10.2.0.1 sqlplus windows
> client takes < 1 sec from same client machine.
>
> Where do I begin? I have an SR opened with Oracle but they are taking
> forever. I've generated sqlnet.ora trace files for both and a listener
> trace file for both logons. I don't know much about reading the trace
> files though. I did notice that a sql statement that I ran as a test
> is displayed in the 9.2.0.5 session's trace file, but it isn't in
> 10.2.0.2 trace file.

I'm just doing some way-out-in-left-field speculating here.

Are you using ASSM? I'm wondering about the bugs that use excessive cpu, perhaps the login is trying to insert into some audit or login table and hitting the performance bugs. Watch the cpu usage while the problem is happening. See 10.2.0.3 patch notes for details (ASSM, as well as hig cpu usage bugs, hangs, Memory leak [MMON and repeated connect/disconnect). Same issue when sqlplus directly on the server?

How consistent are the results? Just on windows server for me, first login takes way longer. Could AIX be swapping out unused 10g processes? lsnrctl status giving expected results? MMON making things way big?

Statistics on system? (see http://jonathanlewis.wordpress.com/2007/05/20/system-stats-strategy/ I'm wondering if you see other things wrong besides the login)

Bounced the instance? (If that connect/disconnect memory leak isn't just OCi...)

Anything in alert log?

Other systems with the same name far away? :-)

jg

--
@home.com is bogus.
Wheeee! http://www.signonsandiego.com/uniontrib/20070725/news_1b25amazon.html