Re: connection to the database is slow

On v7( don't know which release) SQL*Net logging ( or trace, can't remember ) was enabled by default and would make connection process very slow. ( Problem similar to one with slow export on this list ). Check is trace/logging is enabled.

On 2/3/06, Joseph Amalraj <joseph_at_amalrajinc.com> wrote:
>
>
> Try connecting on the same box as the database thru' tnsnames.ora (tcp)
> connection. If it is still slow it is a listener issue.
>
> Check if listener is one of the top processes. The listener may be having
> a lot of workload, in which case listener process can be assigned a higher
> priority or a second listener can be created (but on a different port - and
> this may not be preferred).
>
> Load on the listener can be reduced by turning the local database
> connections to "bequeath" instead of ipc or tcp.
>
> Regards
>
> Joseph Amalraj
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto: oracle-l-bounce_at_freelists.org] On Behalf Of Radoulov, Dimitre
> Sent: Friday, February 03, 2006 11:28 AM
> To: ikar_at_med.cornell.edu
> Cc: oracle-l_at_freelists.org
> Subject: Re: connection to the database is slow
>
> > It takes a long time to get connected to our Oracle 8i database.
> > Once connection got established the performance is OK. However it may
>
> > take few minutes to get connected.
> > We are in dedicated mode. Any points how to investigate the problem?
>
> I would check for DNS issues first: try to configure the
> tnsnames.ora/jdbc
> url etc with IP address instead of machine/logical host name.
>
> If the problem is not there, check for lack of resources on the DB
> server(especially for available memory) and try to activate the
> OracleNet
> tracing.
>
>
>
> Regards,
> Dimitre
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> LEGAL DISCLAIMER
> The information transmitted is intended solely for the individual or
> entity to which it is addressed and may contain confidential and/or
> privileged mat erial. Any review, retransmission, dissemination or other use
> of or taking action in reliance upon this information by persons or entities
> other than the intended recipient is prohibited. If you have received this
> email in error please contact the sender and delete the material from any
> computer.
>
> Seeing Beyond Money is a service mark of SunTrust Banks, Inc.
> [ST:XCL]
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html

--
http://www.freelists.org/webpage/oracle-l