Re: Can't find the sql text from v$sql via the hash value

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

2006/6/17, eagle fan <eagle.f@xxxxxxxxx>:

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
--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: Can't find the sql text from v$sql via the hash value
  - From: eagle fan

References:
- Can't find the sql text from v$sql via the hash value
  - From: eagle fan
- Re: Can't find the sql text from v$sql via the hash value
  - From: Dennis Williams
- Re: Can't find the sql text from v$sql via the hash value
  - From: eagle fan
- Re: Can't find the sql text from v$sql via the hash value
  - From: eagle fan