今天发现dg 11.2.0.1备库里alter.log里报
RFS[11]: Selected log 4 for thread 1 sequence 14934 dbid 1020656503 branch 787682297
Wed Apr 09 08:00:38 2014
Archived Log entry 9696 added for thread 1 sequence 14933 ID 0x3d183f75 dest 1:
Wed Apr 09 08:00:40 2014
Media Recovery Log /data/ora_archive/1_14933_787682297.dbf
Wed Apr 09 08:01:24 2014
Media Recovery Waiting for thread 1 sequence 14934 (in transit)
Wed Apr 09 08:10:50 2014
Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=44924):
ORA-04030: out of process memory when trying to allocate 496 bytes (Alloc statemen,alloc bind hndl)
Incident details in: /u01/app/diag/rdbms/hz_dg2/hz/incident/incdir_44924/hz_mmon_22604_i44924.trc
Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=44925):
ORA-04030: out of process memory when trying to allocate bytes (,)
Incident details in: /u01/app/diag/rdbms/hz_dg2/hz/incident/incdir_44925/hz_mmon_22604_i44925.trc
Wed Apr 09 08:10:57 2014
Trace dumping is performing id=[cdmp_20140409081057]
Trace dumping is performing id=[cdmp_20140409081058]
Wed Apr 09 08:10:58 2014
Sweep [inc][44925]: completed
。。。。。。。。。。。。。。。。。。。。。。。。。。。
Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=45625):
ORA-04030: out of process memory when trying to allocate 1752 bytes (Alloc environm,alloc statement hndl)
Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=45626):
ORA-04030: out of process memory when trying to allocate bytes (,)
Errors in file /u01/app/diag/rdbms/hz_dg2/hz/trace/hz_mmon_22604.trc (incident=45627):
ORA-04030: out of process memory when trying to allocate 432 bytes (session heap,kqdAlloc)
Wed Apr 09 08:59:14 2014
Sweep [inc][45627]: completed
Sweep [inc][45626]: completed
Sweep [inc][45625]: completed
more /u01/app/diag/rdbms/hz_dg2/hz/incident/incdir_44924/hz_mmon_22604_i44924.trc
*** 2014-04-09 08:14:19.640
44% 1737 MB, 6868633 chunks: "mark "
Alloc statemen ds=0x2abc9dbe3980 dsprt=0x2abb9e0ee8b0
41% 1640 MB, 981240 chunks: "mark "
Alloc environm ds=0x2abb9e0ee8b0 dsprt=0x2abb9e0c5fa0
13% 515 MB, 1046650 chunks: "free memory "
Alloc statemen ds=0x2abc9dbe3980 dsprt=0x2abb9e0ee8b0
2% 91 MB, 981234 chunks: "permanent memory "
Alloc statemen ds=0x2abc9dbe3980 dsprt=0x2abb9e0ee8b0
0% 616 KB, 24 chunks: "permanent memory "
pga heap ds=0xa99d240 dsprt=(nil)
0% 296 KB, 1 chunk : "kfk_kfkio_freeq