RE: VLM Configuration Problem

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Thu, 16 Dec 2004 19:29:10 -0500
Message-ID: <AFF54B073FF15849B53E32E67EE860760144F1BA@enhbgpri11.backup>

Whoops, error. PGA aggregate target is 2G.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Freeman, Donald Sent: Thursday, December 16, 2004 7:12 PM To: Oracle-L (E-mail)
Subject: VLM Configuration Problem

I am trying to configure an Oracle 9.2.0.5 data warehouse database on Windows 2003 to use VLM. I have 4G of memory on this machine. I have configured the 3GB switch in the boot.ini, changed my db_cache to db_block_buffers, added the USE_INDIRECT_DATA_BUFFERS=3D3D TRUE = parameter,
rebooted the server and no matter what I set db_block_buffers to I get this error on two out of three machines. I can' t figure out the difference.

OS-Error: (OS 8) Not enough storage is available to process this command

The reason we are doing this is that I am getting an out-of-process memory error while running our etl job. I have forestalled this error by reducing the db_cache size to .9 G from 1 G. PGA aggregate target is 1 G. =3D20

My memory is allocated as follows:

Total System Global Area           1430858356 bytes
Fixed Size                             457332 bytes
Variable Size                       452984832 bytes
Database Buffers                    973078528 bytes
Redo Buffers                          4337664 bytes

Where do I start looking from here?

Don Freeman
Database Administrator 1
Pennsylvania Dept of Health
Bureau of Information Technology

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 16 2004 - 18:30:18 CST