今天早上开始oracle开始出问题。 Alert Log Generic Alert Log Error ORA 错误堆栈 (04030) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-25 9:59:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (04030) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-25 9:44:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (04030) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-25 9:29:39
Alert Log Session Terminated Alert Log Error 会话在以下时间/行号终止: Thu Mar 25 09:25:25 2010/2417。 2010-3-25 9:29:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (04030, 04030) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-25 9:29:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (00600[1234], 00600[729]) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 17:59:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (00600[729]) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 17:59:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (12012, 04030, 06512, 06512, 06512) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 14:59:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (00604, 04030, 12012, 04030, 06512, 06512, 06512) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 14:29:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (12012, 04030, 06512, 06512, 06512) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 14:29:39
[code]alert_orcl.log中内容截取部分如下:
[code=Java]
Thu Mar 25 09:55:20 2010
Doing block recovery for file 2 block 654
Thu Mar 25 09:55:20 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:20 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:20 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Thu Mar 25 09:55:30 2010
Doing block recovery for file 2 block 654
Thu Mar 25 09:55:30 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:30 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:30 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Thu Mar 25 09:55:40 2010
Doing block recovery for file 2 block 654
Thu Mar 25 09:55:40 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:40 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:40 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Thu Mar 25 09:55:50 2010
Doing block recovery for file 2 block 654
Block recovery from logseq 99, block 88440 to scn 3735751
Thu Mar 25 09:55:50 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 99 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ONLINELOG\O1_MF_2_5QYKG30Y_.LOG
Mem# 1 errs 0: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ONLINELOG\O1_MF_2_5QYKG3WS_.LOG
Block recovery completed at rba 99.88445.16, scn 0.3735754
Doing block recovery for file 1 block 59718
Block recovery from logseq 99, block 88217 to scn 3735751
Thu Mar 25 09:55:50 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 99 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ONLINELOG\O1_MF_2_5QYKG30Y_.LOG
Mem# 1 errs 0: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ONLINELOG\O1_MF_2_5QYKG3WS_.LOG
Block recovery completed at rba 99.88445.16, scn 0.3735754
PMON deletion of process succeeded
Alert Log Generic Alert Log Error ORA 错误堆栈 (04030) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-25 9:44:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (04030) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-25 9:29:39
Alert Log Session Terminated Alert Log Error 会话在以下时间/行号终止: Thu Mar 25 09:25:25 2010/2417。 2010-3-25 9:29:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (04030, 04030) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-25 9:29:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (00600[1234], 00600[729]) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 17:59:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (00600[729]) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 17:59:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (12012, 04030, 06512, 06512, 06512) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 14:59:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (00604, 04030, 12012, 04030, 06512, 06512, 06512) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 14:29:39
Alert Log Generic Alert Log Error ORA 错误堆栈 (12012, 04030, 06512, 06512, 06512) 记录在 D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP\alert_orcl.log 中。 2010-3-24 14:29:39
[code]alert_orcl.log中内容截取部分如下:
[code=Java]
Thu Mar 25 09:55:20 2010
Doing block recovery for file 2 block 654
Thu Mar 25 09:55:20 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:20 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:20 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Thu Mar 25 09:55:30 2010
Doing block recovery for file 2 block 654
Thu Mar 25 09:55:30 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:30 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:30 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Thu Mar 25 09:55:40 2010
Doing block recovery for file 2 block 654
Thu Mar 25 09:55:40 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:40 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Doing block recovery for file 2 block 654
Thu Mar 25 09:55:40 2010
Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_pmon_4156.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo overflow buffer)Thu Mar 25 09:55:50 2010
Doing block recovery for file 2 block 654
Block recovery from logseq 99, block 88440 to scn 3735751
Thu Mar 25 09:55:50 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 99 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ONLINELOG\O1_MF_2_5QYKG30Y_.LOG
Mem# 1 errs 0: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ONLINELOG\O1_MF_2_5QYKG3WS_.LOG
Block recovery completed at rba 99.88445.16, scn 0.3735754
Doing block recovery for file 1 block 59718
Block recovery from logseq 99, block 88217 to scn 3735751
Thu Mar 25 09:55:50 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 99 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ONLINELOG\O1_MF_2_5QYKG30Y_.LOG
Mem# 1 errs 0: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ONLINELOG\O1_MF_2_5QYKG3WS_.LOG
Block recovery completed at rba 99.88445.16, scn 0.3735754
PMON deletion of process succeeded
解决方案 »
- 一个简单的sql语句的实现
- ??菜鸟提问:Oracle10g在IE的OEM图形界面里怎么给新建立的用户授权??
- oracle数据库中,说orwid是一个18位数字,以64位为基数?
- oracle 连接的问题
- oracle游标问题
- oracle数据库条件查询的问题
- 关于触发器XXXXX的问题 总报错 插入的问题 搞不懂 高手请进!!!!
- ####为什么相同的代码,第二次比第一次要快?####
- 分区可以多个字段同时分区吗?
- 安装Oracle9i后,无法启动OracleOracle9iTNSListener和OracleOracle9iAgent服务,这是怎么回事呀?请各位高手帮忙
- oracle查询建表失败
- 急救!操作失误,如何进行恢复,在线等--
// *Cause: Operating system process private memory has been exhausted
// *Action:
PGA给大点,块恢复时发现进程PGA内存不够。
你的各个内存区大小是auto还是手工分配
在分配pga的时候内存报错,pga太小
有可能是程序跑的太多了,不过个人觉得内存物理故障