The memory monitor (MMON) process was introduced in 10g and is associated with the Automatic Workload Repository new features used for automatic problem detection and self-tuning. MMON writes out the required statistics for AWR on a scheduled basis.监控内存的进程,这个trace文件应该是取消不掉的。 虽然数量多, 但占用空间不大,而且这里面有很多有用的信息。 楼主要是闲多,定期删除就是了 ..
刚才看了下,是系统的错误。。 212653A8 418 package body SYS.DBMS_HA_ALERTS_PRVT 212653A8 552 package body SYS.DBMS_HA_ALERTS_PRVT 212653A8 305 package body SYS.DBMS_HA_ALERTS_PRVT 20E97A08 1 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- _ksedst+38 CALLrel _ksedst1+0 0 1各位看下,有什么好的解决方法
*** SERVICE NAME:(SYS$BACKGROUND) 2009-10-20 15:25:29.812 *** SESSION ID:(161.37) 2009-10-20 15:25:29.812 *** 2009-10-20 15:25:29.812 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], [] Current SQL statement for this session: BEGIN :success := dbms_ha_alerts_prvt.check_ha_resources; END; ----- PL/SQL Call Stack ----- object line object handle number name 212653A8 418 package body SYS.DBMS_HA_ALERTS_PRVT 212653A8 552 package body SYS.DBMS_HA_ALERTS_PRVT 212653A8 305 package body SYS.DBMS_HA_ALERTS_PRVT 20E97A08 1 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- _ksedst+38 CALLrel _ksedst1+0 0 1 _ksedmp+898 CALLrel _ksedst+0 0 _ksfdmp+14 CALLrel _ksedmp+0 3
*** SERVICE NAME:(SYS$BACKGROUND) 2009-10-20 15:25:29.812 *** SESSION ID:(161.37) 2009-10-20 15:25:29.812 *** 2009-10-20 15:25:29.812 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], [] Current SQL statement for this session: BEGIN :success := dbms_ha_alerts_prvt.check_ha_resources; END; ----- PL/SQL Call Stack ----- object line object handle number name 212653A8 418 package body SYS.DBMS_HA_ALERTS_PRVT 212653A8 552 package body SYS.DBMS_HA_ALERTS_PRVT 212653A8 305 package body SYS.DBMS_HA_ALERTS_PRVT 20E97A08 1 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- _ksedst+38 CALLrel _ksedst1+0 0 1 _ksedmp+898 CALLrel _ksedst+0 0 _ksfdmp+14 CALLrel _ksedmp+0 3
是Bug 5173066。 你数据库啥版本?自己查metalink或网上找解决方法。
呢你是怎末知道是bug 5173066 ???
我觉得你现在重点应该放在如何解决这个bug上。
问题现在暂时解决了,想知道你找到bug 5173066 的方法
create table recent_resource_incarnations$bk as select * from recent_resource_incarnations$; truncate table recent_resource_incarnations$; shutdown immediate;
The memory monitor (MMON) process was introduced in 10g and is associated with the Automatic Workload Repository new features used for automatic problem detection and self-tuning. MMON writes out the required statistics for AWR on a scheduled basis.监控内存的进程,这个trace文件应该是取消不掉的。 虽然数量多, 但占用空间不大,而且这里面有很多有用的信息。 楼主要是闲多,定期删除就是了 ..
212653A8 418 package body SYS.DBMS_HA_ALERTS_PRVT
212653A8 552 package body SYS.DBMS_HA_ALERTS_PRVT
212653A8 305 package body SYS.DBMS_HA_ALERTS_PRVT
20E97A08 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedst+38 CALLrel _ksedst1+0 0 1各位看下,有什么好的解决方法
*** SESSION ID:(161.37) 2009-10-20 15:25:29.812
*** 2009-10-20 15:25:29.812
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Current SQL statement for this session:
BEGIN :success := dbms_ha_alerts_prvt.check_ha_resources; END;
----- PL/SQL Call Stack -----
object line object
handle number name
212653A8 418 package body SYS.DBMS_HA_ALERTS_PRVT
212653A8 552 package body SYS.DBMS_HA_ALERTS_PRVT
212653A8 305 package body SYS.DBMS_HA_ALERTS_PRVT
20E97A08 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedst+38 CALLrel _ksedst1+0 0 1
_ksedmp+898 CALLrel _ksedst+0 0
_ksfdmp+14 CALLrel _ksedmp+0 3
*** SESSION ID:(161.37) 2009-10-20 15:25:29.812
*** 2009-10-20 15:25:29.812
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kjhn_post_ha_alert0-862], [], [], [], [], [], [], []
Current SQL statement for this session:
BEGIN :success := dbms_ha_alerts_prvt.check_ha_resources; END;
----- PL/SQL Call Stack -----
object line object
handle number name
212653A8 418 package body SYS.DBMS_HA_ALERTS_PRVT
212653A8 552 package body SYS.DBMS_HA_ALERTS_PRVT
212653A8 305 package body SYS.DBMS_HA_ALERTS_PRVT
20E97A08 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedst+38 CALLrel _ksedst1+0 0 1
_ksedmp+898 CALLrel _ksedst+0 0
_ksfdmp+14 CALLrel _ksedmp+0 3
你数据库啥版本?自己查metalink或网上找解决方法。
truncate table recent_resource_incarnations$;
shutdown immediate;
create table r_r_i$bk as select * from recent_resource_incarnations$;
truncate table recent_resource_incarnations$;
shutdown immediate;