Re: Oracle DBA questions

Check these settings:
- on NT server go to the Control Panel --> Network --> Services --> Server --> Properties --> select Maximize throughput for network app. - on the client check bindings (Control Panel, Network) and put TCP/IP on top
- I prefer IP numbers over hostnames in TNSNAMES.ORA for my NT servers to avoid name resolution delay
- ping your Unix and NT box and compare the results, perhaps there is some network bottleneck

I have connect time up to 1 sec on NT (4xCPU, FDDI 100Mbps, Oracle 7.3.4, 8.0.5, 8.1.5) from my client (Net8, 10Mbps Ethernet).

bye,
Ales
OCP/DBA, MCSE, MCP+I

Yves <yves_at_staf.pi.be> wrote in message news:7sdc9c$au0$1_at_news.planetinternet.be...
> Do you know anything about oracle on NT ?
>
> My NT takes much more time than my Unix machine to make
> the connects to the Database. When i connect to the unix it takes
> 0.3 secs. When i do the same to a Windows NT with the same
> DB it takes about 1.4 to 2 secs.
>
> When i use prespawning of connects it is usually faster but oracle support
> told me this aint a good option because when i will get a lot of connects
> the DB will fall back in his old habit.
>
> So my question is : "Do you know how i can make it faster ?"
>
> thx in advance
> Yves
>
Received on Fri Sep 24 1999 - 03:46:43 CDT