Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How To Improve Connection Times?
"Mladen Gogala" <mgogala_at_adelphia.net> wrote in message
news:acol73$r854c$1_at_ID-82084.news.dfncis.de...
> On Sat, 25 May 2002 13:02:43 -0400, Sybrand Bakker wrote:
>
> > This must be a network and/or a sqlnet configuration issue. You don't
> > provide any details on that. We need to have listener.ora, tnsnames.ora
> > and sqlnet.ora Also we need to know whether the client can ping the
> > server in a reasonable amount of time, what the traceroute results are
> > between the systems, and whether a firewall is involved.
>
> Here I have to respectfully disagree. It seldomly an Oracle*Net issue,
> it's usually a network problem. In my experience, long connection times
> have usually been related to memory problems, because the kernel has to
> page the ora_s0000n_$SID process in the memory. If there is an enormous
> SGA, there may be a delay with paging in the whole SGA. In that case,
> pre_page_sga parameter mightt help, as well as "lock_sga".
> If it was my machine, I'd first do a ping to see what times do I get and
> if it turs out OK (~5ms or less), then look at gtop and see whether there
> is excessive paging. You can also use sar or iostat from sysstat package.
> for that purpose. If not, turn the tracing in the listener (level=ADMIN)
> and see whether you can figure out what is it waiting for.
> --
> Mladen Gogala
> Za Feral Spremni!
Sorry to be hairsplitting, but where do you read the OP is using MTS? Where
do you read the OP is using any Unix platform? Also you must be aware
connecting using service_name = in tnsnames.ora is usually faster than
connecting using SID = in tnsnames.ora
Also do you really think the listener.ora show any traces of waiting , where
it is the *client* that has trouble connecting?
So, finally, why do you feel the need to piss me off, without even reading
the request of the OP
Regards
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail addressReceived on Sat May 25 2002 - 15:38:43 CDT