Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connect slower than on informix

Re: connect slower than on informix

From: Peter Franz <PeterFr_at_aol.com>
Date: 15 Nov 2002 10:13:09 -0800
Message-ID: <34e6d529.0211151013.140247ad@posting.google.com>


dyou98_at_aol.com (D.Y.) wrote in message news:<f369a0eb.0211061851.70326a24_at_posting.google.com>...

> Johann Kropf <Johann.Kropf_at_gmx.net> wrote in message news:<3dc8bf0f$0$25572$91cee783_at_newsreader02.highway.telekom.at>...

> > why is the connect to oracle slower than to informix?
> > informix takes about 1 second and oracle about 7 seconds.
> > tested with sqlpus for oracle and isql for informix.
> >

Hi,

try to comment out the line:

# SQLNET.AUTHENTICATION_SERVICES= (NTS) in your sqlnet.ora file.
This reduce my connection time from 8 to 1 second! Best regards
Peter Received on Fri Nov 15 2002 - 12:13:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US