OraFAQ Forum: Networking and Gateways » tnsping with dropouts

Home » RDBMS Server » Networking and Gateways » tnsping with dropouts

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tnsping with dropouts [message #115412]

Mon, 11 April 2005 07:48

veittes
Messages: 3
Registered: April 2005

Junior Member

Hi,

we've performance problems with Oracle 9i database on IBM AIX Regatta Server and Windows2003 server machine (as oracle client):

tnsping <instance> 100
gets:
0ms
0ms
0ms
0ms
3000ms
0ms
20ms
0ms
0ms
0ms
2800ms
0ms
10ms
0ms
....

and so on.

Simple SQL Select statements have most response time at 0 ms, but there are many that have about 400ms each (1000 equal select statements to Oracle DB), this was seen in oracle client trace file. The Oracle DB server has no wait time.

Other clients have not tnsping dropouts to the database.

Whats the matter?

Yours,
Markus
--
Markus Veittes

Report message to a moderator

Re: tnsping with dropouts [message #115416 is a reply to message #115412]

Mon, 11 April 2005 08:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

TNSPING checks the availablity of Listener in serverside. Thats it.

>>but there are many that have about 400ms each (1000 equal select statements to Oracle DB)

Are you sure that these sql are good? ( base tables /indexes analyzed ) etc?

Turn of the sql*net tracing and try again ( tracing has some overhead).

How is the listener configured? Is the listener serving only ONE instance or more?
If the two machines are in differnt sub-nets try the network performacne at the system level ( a simple test is to swap a file between the two machines / filesytems.).

Report message to a moderator

Re: tnsping with dropouts [message #115417 is a reply to message #115416]

Mon, 11 April 2005 08:53

veittes
Messages: 3
Registered: April 2005

Junior Member

Mahesh Rajendran wrote on Mon, 11 April 2005 15:22

TNSPING checks the availablity of Listener in serverside. Thats it.

How is the listener configured? Is the listener serving only ONE instance or more?
If the two machines are in differnt sub-nets try the network performacne at the system level ( a simple test is to swap a file between the two machines / filesytems.).

The listener serves only one instance, but there are more listeners on the same machine for the other instances.
The transfer rate for 1 GByte file from client to DB server was about 8 MByte/s. (100 mbit network)

Report message to a moderator

Re: tnsping with dropouts [message #115778 is a reply to message #115417]

Thu, 14 April 2005 07:31

veittes
Messages: 3
Registered: April 2005

Junior Member

The switch makes the latence time.
We've put the oracle client to another switch, everything worked OK.

Markus

Report message to a moderator

Previous Topic:	Configuring two listeners
Next Topic:	ORA-12545 Error "Connect Failed Target host or object does not exist", pls HELP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 03:51:21 CDT 2025