oracle 表刷出内存不足,oracle内存不足挂起

win 2003 sp2 32位的操作系统，内存8G，oracle 10g的，sga只有1.7G，现在跑数经常报内存不足的错：

Dump file h:\oracle\product\10.2.0\admin\orcl\bdump\orcl_lgwr_868.trc

Wed Jan 19 14:21:50 2011

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                 : 16 - type 586, 2 Physical Cores

Process Affinity    : 0x00000000

Memory (Avail/Total): Ph:3971M/8181M, Ph+PgF:5884M/10032M, VA:146M/2047M

Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 20

Windows thread id: 868, image: ORACLE.EXE (LGWR)

*** SERVICE NAME

) 2011-01-19 14:21:50.296

*** SESSION ID

69.1) 2011-01-19 14:21:50.296

Maximum redo generation record size = 156160 bytes

Maximum redo generation change vector size = 150672 bytes

*** 2011-01-19 14:24:15.718

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:24:50.921

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:25:26.109

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:25:58.953

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:26:27.562

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:26:47.656

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:27:04.750

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:27:31.531

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:27:45.140

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:28:04.812

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:28:24.890

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:28:45.156

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:56:46.437

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:56:58.593

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:57:15.625

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:57:31.500

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:57:53.671

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:58:12.359

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:58:27.625

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 14:58:50.031

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 15:40:31.328

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 15:40:46.765

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 15:41:00.546

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 15:41:20.234

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 15:41:36.078

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 15:41:56.625

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 15:42:15.109

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 15:42:31.703

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 15:42:52.656

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:01:13.078

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:01:31.390

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:01:44.828

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:02:05.875

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:02:24.062

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:02:38.968

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:02:54.578

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:03:16.781

Media recovery not enabled or manual archival only 0x10000

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:03:36.796

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:22:43.953

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 16:31:25.890

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 19:00:51.828

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:05:43.765

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:06:51.703

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:07:50.984

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:09:41.265

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:10:49.578

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:12:01.625

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:13:41.656

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:15:10.578

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:16:47.171

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:17:57.968

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:18:57.421

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:20:03.078

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:20:52.796

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:21:51.484

Media recovery not enabled or manual archival only 0x10000

*** 2011-01-19 22:22:48.484

error 4030 detected in background process

ORA-04030: 在尝试分配  字节 (,) 时进程内存不足

[本帖最后由 liangf215 于 2011-1-20 15:27 编辑]