"tnsping" has nothing to do with the database -- it just
"looks - up" the listener
to see if the listener is listening for that service. Therefore,
the number of
processes connected to the database makes no difference.
Could you post the TNSNAMES.ORA file here ?
Hemant
At 01:16 AM 04-02-03 -0800, you wrote:
Ferenec ,
List
tnsnames.ora has been setup on the Database Server
itself & tnsping is being issued also from the Database Server itself
to avoid any network path.
For the SAME ORACLE_HOME & using the SAME
tnsnames.ora file tnsping to the 2 Databases on the DB Server
machine is taking 10,000 ms & 10 ms respectively
Can there be any overheads / other concerns with
usign this parameter , as respective machines are Production Servers
?
Thanks indeed
- -----Original Message-----
- From: Ferenc Mantfeld
[mailto:mantfield@connexus.net.au]
- Sent: Tuesday, February 04, 2003 1:10 AM
- To: Multiple recipients of list ORACLE-L
- Subject: Re: SQL*Net Connection under-performing
- 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 ?
-
Hemant K Chitale
My web site page is :
http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: hkchital@singnet.com.sg
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Feb 04 2003 - 06:38:45 CST
