Re: sql connect got slow

interesting suggestions.

I am running on the same machine that the server is running on. But I get the same slow initial connect when I try to go to an outside server. I can connect fast to the same outside server from another client machine. So it seems it particular to the machine with Win2k on it.

 I will try the suggestion an let you know...thanks....ed

<hailey_kyle_at_my-deja.com> wrote in message news:9401t8$c5i$1_at_nnrp1.deja.com...
> you might want to take a look at the file
> network/admin/sqlnet.ora (or net80/admin whatever)
> and set
>
> automatic_ipc=off
>
> Problems can depend on the version of Oracle. Some Oracle 7 releases
> had some wonderful bugs where otrace was running automatically and
> needed to be set off in the init.ora. On windows it could also be
> related to loading dlls. IF your client isn't on the server machine it
> would be interesting to know if you get the same problem connecting on
> the server machine, if not then do you get the problem connecting over
> a TCP to the severmachine (loopback). Doing these kinds of tests helps
> pinpoint the problem area.
>
> If nothing works you can try system call tracing (there is a free
> strace program out there for NT) or Oracle net tracing in the
> sqlnet.ora file,ie
>
> trace_level_client=16
> trace_unique_client=true
> trace_file_client=cli_
> trace_directory_client= /temp
>
>
> Best
> Kyle
>
> http://www.geocities.com/oraperf
>
> In article <93vk1m$b3n$1_at_bob.news.rcn.net>,
> "Ed Zappulla" <zappullae_at_rcn.com> wrote:
> > I upgraded to 8.1.7 and have the same initial slowness on connection
 to
> > Oracle from sqlplus and sqlldr. Very strange.
> >
> > is this a wn2k incompaitability?
> >
> > "Ed Zappulla" <zappullae_at_rcn.com> wrote in message
> > news:93qg28$gns$1_at_bob.news.rcn.net...
> > > Hi, I just upgraded to win2k pro and resinstalled ora 8.1.6
 Enterprise.
> > >
> > > Everything works fine but it looks like SQLPLUS and all db
 connection take
 a
> > > lot of time to connect initialy. Then thier fine.
> > >
> > > My guess its a TCP/IP time 75 sec out.
> > >
> > > Any ideas as to what configuration I need to change to make the
 connection
> > > quick?
> > >
> > > ...ed
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Jan 16 2001 - 06:26:36 CST