Solved

ORA-04030: out of process memory when trying to allocate

Posted on 2009-04-03
5
3,861 Views
Last Modified: 2013-11-22
For some reason, I start to get this error on my Oracle database in varies applications. It seems that when we run more BI applications, it starts to occur, but that's just pure speculation. It has occured in BI, ERP etc. applications lately.

ERROR: CLI open cursor error: [Oracle][ODBC][Ora]ORA-04030: out of process memory when trying to allocate 139776 bytes (cursor work he,kllcqas:kllsltba)

What does this really mean? I couldn't seen to find a good solution from Google.
0
Comment
Question by:PaperTiger
  • 2
  • 2
5 Comments
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24064874
You have a general memory problem. Not sure which, but you need to check several things.

What OS are you using?
Which Oracle version?

You could be hitting user soft/hard limits, please post (UNIX> ulimit -a)
You could have your kernel configured with too little memory. Use appropriate command to find out how your memory usage looks from the OS level first.

Need to know which Oracle to give you correct advice.
0
 
LVL 11

Expert Comment

by:mohammadzahid
ID: 24065657
Ora-04030 is caused by shortage of memory.
Goto this site for more information and options that you can try to resolve this error message.

http://www.dba-oracle.com/t_ora_04030_out_process_memory.htm

0
 
LVL 8

Author Comment

by:PaperTiger
ID: 24065690
It's Oralce 8.1.6 on Windows 2000 Srv 32 bit with 4GB memory installed serving about 50 users.

SVRMGR> show sga
Total System Global Area                       1611,133,916 bytes
Fixed Size                                          70,620 bytes
Variable Size                                   585,940,992 bytes
Database Buffers                               1,023,639,552 bytes
Redo Buffers                                      1,482,752 bytes

0
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 500 total points
ID: 24065739
Anything else running on that box that requires ram, besides windows itself?
Only one Oracle instance?

You can set your OS (C:\boot.ini I think) with switches to allow more RAM usage by Oracle, but even with your current SGA you are using a good bit of your overall memory.

These switches might help.

/PAE /USRENV /3GB

http://www.dba-oracle.com/oracle_tips_ram_waste.htm

Before changing anything, monitor the ram usage from the OS side and see how much memory _usage_ you have. You might be at a point where you are simply exhausting based on too many simultaenous users.
You could also consider using multi-threaded server to reduce overall RAM usage.

It might be time for a server upgrade, at least be prepared for this possibility.
0
 
LVL 8

Author Comment

by:PaperTiger
ID: 24157920
I put this in a wrong zone. can admin move this to Oracle zone?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Ransomware continues to be a growing problem for both personal and business users alike and Antivirus companies are still struggling to find a reliable way to protect you from this dangerous threat.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now