Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [Q] Server Logon Performance
first off, your posting is appropiate...Ok 2 reasons (that I know of for
slow connection):
1) Most common is That when you log into Oracle, it creates a default
trace dump, as these files grow larger, the longer you have to wait to
connect.
2) One I have encountered, is in your SQL NET Configeration...(for me) I
have found out if I list more than 2 or 3 IP addresses in my TNS.ora
file, my connection to oracle is delayed.
The second option is from personal experience, I don't know if others have had the same problem as I, However the Trace dumps are commonly known to delay connection time.
Satar Naghshineh
SatarNag_at_worldsite.com
Clayton J Andrews wrote:
>
> Greetings all,
>
> Can anyone offer advice or comment on the reasons for abnormally slow
> logons to Oracle 7?
>
> The machine we're running is an IBM/J30 Quad Processor/256Mb RAM, so
> it's unlikely that this is causing the speed problem...
>
> All other transactions are more than acceptable once you're logged on,
> but to get to this point takes roughly 15-20 secs. Is this normal, or
> can something be done about it.
>
> If this message is in the wrong group, i appologise profusely
>
> Thanks in advance
> Clayton J Andrews
Received on Mon Sep 08 1997 - 00:00:00 CDT