Try to enable 10046 trace. Does application get any ORA- errors or
just disconnects due to timeout?

2006/6/17, eagle fan <eagle.f@(protected)>:
> The hang just last several seconds, after several seconds, the application
> client cancel the operation and mark the database as unavaliable.


--
Best regards,
Alex Gorbachev

http://blog.oracloid.com
--
http://www.freelists.org/webpage/oracle-l