| ORA-04030 Out of process memory [message #58450] |
Wed, 27 August 2003 10:18  |
Roger Morley
Messages: 1
Registered: August 2003
|
Junior Member |
|
|
Can anybody suggest a remedy (ies) for the following Oracle error message:-
ORA-04030 Out of process memory when trying to allocate 4194304 bytes [[cursor work he,QERHJ Bit vector]]:-4030.
It only occcurs when running queries that return large amounts of data (>100,000 lines) and is specific to my server (Compaq Proliant DL360 G2).
The above error is reported through a Business Objects (BO) front end which acts as the query and reporting tool for the Oracle database.
The BO and Oracle database are both running under windows 2000 Server Edition at SP3. Details of the server configuration are shown below.
OS Name Microsoft Windows 2000 Server
Version 5.0.2195 Service Pack 3 Build 2195
OS Manufacturer Microsoft Corporation
System Manufacturer Compaq
System Model ProLiant DL360 G2
System Type X86-based PC
Processor x86 Family 6 Model 11 Stepping 1 GenuineIntel ~1396 Mhz
Processor x86 Family 6 Model 11 Stepping 1 GenuineIntel ~1396 Mhz
BIOS Version 03/19/02
Windows Directory C:WIN2K
System Directory C:WIN2KSystem32
Boot Device DeviceHarddisk0Partition2
Total Physical Memory 2,096,664 KB
Available Physical Memory 1,578,256 KB
Total Virtual Memory 8,231,296 KB
Available Virtual Memory 6,294,220 KB
Page File Space 6,134,632 KB
Page File C:pagefile.sys
Page File E:pagefile.sys
The SQL script that I'm running (generated by Business Objects) is:-
SELECT DISTINCT
NET_CALL.CALL_ID,
NET_CALL_END_POINT_VIEW.SOURCE_PORT_ADDRESS,
NET_CALL_END_POINT_VIEW.DEST_PORT_ADDRESS,
NET_HOP.NET_HOP_NUMBER,
HOP_DIRECTION_TYPES.HOP_DIRECTION_TYPE,
HOP_TYPES.HOP_TYPE,
NET_HOP_END_POINTS.HOP_NAME,
NET_HOP_END_POINTS.SOURCE_PORT_ADDRESS,
NET_HOP_END_POINTS.DEST_PORT_ADDRESS
FROM
NET_CALL,
NET_CALL_END_POINT_VIEW,
NET_HOP,
HOP_DIRECTION_TYPES,
HOP_TYPES,
NET_HOP_END_POINTS,
NET_ROUTE
WHERE
( NET_HOP.NET_ROUTE_ID=NET_ROUTE.NET_ROUTE_ID )
AND ( HOP_DIRECTION_TYPES.HOP_DIRECTION_TYPE_NUM=NET_HOP.NET_HOP_DIRECTION )
AND ( HOP_TYPES.HOP_TYPE_NUM=NET_HOP.NET_HOP_TYPE )
AND ( NET_ROUTE.NET_CALL_ID=NET_CALL.NET_CALL_ID )
AND ( NET_CALL_END_POINT_VIEW.NET_CALL_ID=NET_CALL.NET_CALL_ID )
AND ( NET_HOP_END_POINTS.NET_HOP_ID=NET_HOP.NET_HOP_ID )
AND ( NET_HOP.NET_HOP_DIRECTION = HOP_DIRECTION_TYPES.HOP_DIRECTION_TYPE_NUM )
AND ( NET_HOP.NET_HOP_TYPE = HOP_TYPES.HOP_TYPE_NUM )
The Oracle database is at version 8.1.7. and Business Objects is at version 5.1.2.
Many thanks,
Roger
|
|
|
|
| Re: ORA-04030 Out of process memory [message #58472 is a reply to message #58450] |
Fri, 29 August 2003 14:10  |
Kartik Nair
Messages: 15
Registered: August 2003
|
Junior Member |
|
|
Increase the system memory allocation. Im used to UNIX OS and for that I edit the /etc/system file to increase the shared memory for the server and then reboot.
I believe for Windows Systems it should be boot.ini file.
SOLUTION: ========
1) Reduce system SGA
2) Reduce PGA/UGA contents (Sort_area_size)
3) Increase memory addressability from "A" G to "A+1" G. eg: if you already have 3 G then make it 4 G
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
