Hi,

maybe Oracle tool tnsping is of some help for you.

see: http://tahiti.oracle.com/pls/db10g/db10g.drilldown?
remark=quick_search&word=tnsping

If you want to diagnose OS level try ping and traceroute.

Maybe there is a crontab job canibalizing resources.

regards,

Toni

>> I have this problem where logon time is very long ranging from 500
>> msec to 17000+ msec. Accordingf to EM's map. How do I diagnose
>> this problem. Some of these take place in the middle of the night
>> where no one is working on the system, and there are no scheduled
>> job.

--
+-----------------------------------------------------------------+
| Anton Dischner, Unix admin, Oracle-DBA   Phone: +49 89 70953202|
| Institut fuer Klinische Chemie        Fax : +49 89 70958888|
| Klinikum Grosshadern               Home : +49 89 69708766|
| Ludwig Maximilians Universitaet Muenchen Mobil: +49 172 8388880|
| 81366 Muenchen Germany                            |
| Marchioninistr. 15   Anton.Dischner"at"med.uni-muenchen.de   |
+-----------------------------------------------------------------+



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting