| 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
|
|
|
|
|
|
| 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)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
