Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle server hangs up
Hello,
Please help me in following situation:
Oralce 8.1.5, Windows 2000, Small-size database has 6 connections,
While all users work well with some delays, the server is loaded on 100% by
oracle.exe process.
oracle has no additional connection except that 6 and there is no users who
waits for query results.
Only restart of SID service can help, "shutdown immediate" does not work.
Please give me an advice - where to find the source of this problem?
How to determine the sick thread ?
Thank You,
Paul A. Durnoff
dpa_at_mail.ru
Received on Wed Oct 25 2000 - 01:09:14 CDT