|
-
Sarav,
Check the waits for that session. You might find the culprit if you find no blocking locks.
We had a case last week where a session was holding no locks, all other sessions on the instance were shut down, and it was just hung waiting on some system object.
Restarted the instance and problem went away. (deleting an xsd in 9.2.0.4) - oh, and Oracle Support was clueless after 1 full day of traces, dumps, and an rda.
Best of luck,
Last edited by KenEwald; 04-23-2004 at 02:57 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote