oracle.exe突然进程cpu99%了,然后看到后面报错,如下,请高手指点一下,问题所在。
***********************************************************************Fatal NI connect error 12537, connecting to:
(LOCAL=NO) VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 18-2月 -2013 16:02:53
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS: 连接关闭
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (4396) as a result of ORA-609
Mon Feb 18 16:03:28 2013
*********************************************************************** error 12537ORA-609oracle
***********************************************************************Fatal NI connect error 12537, connecting to:
(LOCAL=NO) VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
Time: 18-2月 -2013 16:02:53
Tracing not turned on.
Tns error struct:
ns main err code: 12537
TNS-12537: TNS: 连接关闭
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (4396) as a result of ORA-609
Mon Feb 18 16:03:28 2013
*********************************************************************** error 12537ORA-609oracle
看awr报表里面有几个sql占90%+多是不是有问题?
如图:
awr里面分析出来的Top 5 Timed Foreground EventsTop 5 Timed Foreground Events<table border="1"><tr><th class="awrbg">Event</th><th class="awrbg">Waits</th><th class="awrbg">Time(s)</th><th class="awrbg">Avg wait (ms)</th><th class="awrbg">% DB time</th><th class="awrbg">Wait Class</th></tr>
<tr><td class='awrc'>read by other session</td><td align="right" class='awrc'>13,485,489</td><td align="right" class='awrc'>391,936</td><td align="right" class='awrc'>29</td><td align="right" class='awrc'>38.47</td><td class='awrc'>User I/O</td></tr>
<tr><td class='awrnc'>latch: cache buffers chains</td><td align="right" class='awrnc'>740,348</td><td align="right" class='awrnc'>199,943</td><td align="right" class='awrnc'>270</td><td align="right" class='awrnc'>19.62</td><td class='awrnc'>Concurrency</td></tr>
<tr><td class='awrc'>DB CPU</td><td align="right" class='awrc'> </td><td align="right" class='awrc'>38,732</td><td align="right" class='awrc'> </td><td align="right" class='awrc'>3.80</td><td class='awrc'> </td></tr>
<tr><td class='awrnc'>db file sequential read</td><td align="right" class='awrnc'>1,479,559</td><td align="right" class='awrnc'>20,593</td><td align="right" class='awrnc'>14</td><td align="right" class='awrnc'>2.02</td><td class='awrnc'>User I/O</td></tr>
<tr><td class='awrc'>direct path read</td><td align="right" class='awrc'>41,664</td><td align="right" class='awrc'>7,774</td><td align="right" class='awrc'>187</td><td align="right" class='awrc'>0.76</td><td class='awrc'>User I/O</td></tr>
</table>
[email protected]