Re: SQL*Net Connection under-performing

[Ferenc Mantfeld]

Title: Details about Tar logged

Vivek   I had similar issues with a large customer. I solved this by setting up pre-spawned dedicated processes in the listener. Full in structions available on Metalink. I brought down 1 minute login times to under 10 seconds, by configuring 20 - 40 prespawned connections. Let me know how it works. This can be done relatively easily even in production, configure listener.ora and then simply bounce the listener. Your initial login after that may take you a minute until all the prespawned connections are initiated.   HTH. Regards : Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything. ----- Original Message ----- From: VIVEK_SHARMA To: Multiple recipients of list ORACLE-L Sent: Monday, February 03, 2003 6:58 PM Subject: SQL*Net Connection under-performing SITUATION - With DB Server CPU Idle being  0 %  & load average 60-70 % :- tnsping Connect to one of the  Databases (1) takes about 10,000 ms truss -fdD tnsping <connect string>       29504: 20.0006 18.8113 read(3, "\0 K\0\004\0\0\0 "\0\0 ?".., 2064) = 75   Thus 18....  seconds taken as shown above   Whereas to another Database (2) tnsping takes only 10 ms on the Same machine   DETAILS :- 0) 1 GBPS network path exits from APP Servers to the Database Server.   1) Database 1 Has about 3500 Oracle processes connecting to it Database 2 Has about 1500 Oracle processes connecting to it   2) Both Databases have Different ORACLE_HOMEs   3) sqlnet.ora of Database 1 :- AUTOMATIC_IPC=OFF TRACE_LEVEL_CLIENT=OFF TRACE_LEVEL_SERVER=OFF TNSPING.TRACE_LEVEL=OFF   NO sqlnet.ora exists on Database 2   4) NO process.dat , regid.dat exists in ORACLE_HOME/network/log Dir of ORACLE_HOME for Both Database   5) Multiple listener processes are Running for BOTH Databases   Qs How may the issue be approached ?