Re: 8.0.6 odbc performance

From: Jerry D <jdubuke_at_notme.gpdservices.com>
Date: Wed, 13 Nov 2002 07:58:06 -0500
Message-ID: <3dd24cd7$0$29943$4c41069e@reader0.ash.ops.us.uu.net>

Before I get flamed for not reading the manuals - where can I find the 8.0.6 manuals? Tahiti starts with 8i.
That being said, here is my sqlnet.ora - pretty sparse, and I dont understand it (which is why I would like to read up on it!!)

Looking as far as I can, I see the authentication is commented out - what is the default?
Jerry

*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

TRACE_LEVEL_CLIENT = USER
TRACE_FILE_CLIENT = odbc
TRACE_DIRECTORY_CLIENT = d:\orant\rdbms80\trace

USE_OTRACE = YES #sqlnet.authentication_services = (NONE) names.directory_path = (TNSNAMES, HOSTNAME) names.default_domain = world
name.default.zone = world
automatic_ipc = off
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:3dd17b61$0$9444$cc9e4d1f_at_news.dial.pipex.com...
> have a look at sqlnet.ora and see if it is tring to use nts
authentication.
> if so disable it.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
> "Jerry D" <jdubuke_at_notme.gpdservices.com> wrote in message
> news:3dd1732c$0$11057$724ebb72_at_reader2.ash.ops.us.uu.net...
> > Hi all,
> > We had a meltdown of an Oracle database running on NT Server 4.0. We
> > rebuilt the server from scratch, installed Oracle from scratch,
recreated
> > our database and imported a .dmp file from the previous night to get
back
> > online.
> > Amazingly, the only problem we are now facing is the fact that
connecting
> > via ODBC takes a *lot* longer than it used to. For example, a Microsoft
> > Excel sheet with an ODBC query in it will stay onscreen with "connecting
> to
> > datasource" fro anywhere between 10 and 45 seconds. It will eventually
> > connect, but take such a long time, which never happened before the
> rebuild.
> > I figure I missed sumthin pretty important, and I have not got a cluse
as
> to
> > where to look, since I was sortat thrown into the deep end here.
> > Could someone point me in the right direction to start looking? I would
> > appreciate it!
> >
> > Jerry D
> >
> >
> >
>
>
Received on Wed Nov 13 2002 - 06:58:06 CST