lonnyhe

0 积分	1 好友	6 主题

发消息

[常规总体性能调优] ORA-04030

1^#

发表于 2013-6-4 16:46:17 | 查看: 5285| 回复: 6

环境win2003
oracle 10g
内存参数如下:
SQL> show parameter sga

NAME                               TYPE       VALUE
------------------------------------ ----------- --------
sga_max_size                      big integer 1552M
sga_target                         big integer 1552M
SQL> show parameter pga

NAME                               TYPE       VALUE
------------------------------------ ----------- --------
pga_aggregate_target                big integer 500M
SQL> show parameter process

NAME                               TYPE       VALUE
------------------------------------ ----------- --------
processes                         integer    150
SQL> show parameter session

NAME                               TYPE       VALUE
------------------------------------ ----------- --------
sessions                            integer    170

最近系统总报ora-04030 错误：

Sat Jun 01 15:45:39 2013
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_mman_2976.trc:
ORA-04030: out of process memory when trying to allocate  bytes (,)

Sat Jun 01 15:45:39 2013
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_3048.trc:
ORA-04030: out of process memory when trying to allocate  bytes (,)

Sat Jun 01 15:45:39 2013
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_dbw0_2996.trc:
ORA-04030: out of process memory when trying to allocate  bytes (,)

Sat Jun 01 15:45:40 2013
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_psp0_2960.trc:
ORA-04030: out of process memory when trying to allocate  bytes (,)

Sat Jun 01 15:46:09 2013
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_q001_4120.trc:
ORA-04030: out of process memory when trying to allocate  bytes (,)

Sat Jun 01 15:47:02 2013
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_reco_3088.trc:
ORA-04030: out of process memory when trying to allocate  bytes (,)

Sat Jun 01 15:47:02 2013
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_smon_3080.trc:
ORA-04030: out of process memory when trying to allocate  bytes (,)

Mon Jun 03 15:00:43 2013
Errors in file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_m001_5180.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 40972 bytes (koh-kghu sessi,static frame of inst)
ORA-06512: at "SYS.PRVT_HDM", line 112
ORA-04030: out of process memory when trying to allocate 40972 bytes (koh-kghu sessi,static frame of inst)
ORA-06512: at line 1

附orcl_m001_5180.trc
Dump file e:\oracle\product\10.2.0\admin\orcl\bdump\orcl_m001_5180.trc
Mon Jun 03 15:00:43 2013
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 2
CPU                : 32 - type 586, 4 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:63471M/65535M, Ph+PgF:64519M/66984M, VA:20M/2047M
Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 81

Windows thread id: 5180, image: ORACLE.EXE (m001)

*** ACTION NAME:(Auto ADDM Slave Action) 2013-06-03 15:00:43.562
*** MODULE NAME:(MMON_SLAVE) 2013-06-03 15:00:43.562
*** SERVICE NAME:(SYS$BACKGROUND) 2013-06-03 15:00:43.562
*** SESSION ID:(64.491) 2013-06-03 15:00:43.562
KSV 604 error in slave process
*** 2013-06-03 15:00:43.562
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 40972 bytes (koh-kghu sessi,static frame of inst)
ORA-06512: at "SYS.PRVT_HDM", line 112
ORA-04030: out of process memory when trying to allocate 40972 bytes (koh-kghu sessi,static frame of inst)
ORA-06512: at line 1
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate 40972 bytes (koh-kghu sessi,static frame of inst)
ORA-06512: at "SYS.PRVT_HDM", line 112
ORA-04030: out of process memory when trying to allocate 40972 bytes (koh-kghu sessi,static frame of inst)
ORA-06512: at line 1

请问：Memory (Avail/Total): Ph:63471M/65535M, Ph+PgF:64519M/66984M, VA:20M/2047M 怎么解读呢？
是什么原因造成总是内存不足啊？

分享0