OraFAQ Forum: Server Administration » ORA-04030 : Out of Process Memory

Home » RDBMS Server » Server Administration » ORA-04030 : Out of Process Memory (Oracle,11g,Windows server 32 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04030 : Out of Process Memory [message #537163]

Tue, 27 December 2011 01:18

lekhrajdeshmukh
Messages: 3
Registered: December 2011
Location: India

Junior Member

Dear All,

I am facing this problem continuously from last 1 week on my production oracle database.I have performed all kind of changes on parameter but still am getting this error.Please find the below system detail and init file detail.
Oracle version -> 11g
O/S -> windows server 2003
RAM -> 11 GB

#########################INIT CONFIG###################
convdb.__db_cache_size=536870912
convdb.__java_pool_size=10485760
convdb.__large_pool_size=4194304
convdb.__oracle_base='G:\app\clusadmin'#ORACLE_BASE set from environment
convdb.__pga_aggregate_target=1342177280
#convdb.__sga_target=2415919104
convdb.__shared_io_pool_size=0
convdb.__shared_pool_size=522190848
convdb.__streams_pool_size=0

###########################################
# Diagnostics and Statistics
###########################################
*.audit_file_dest='G:\CONVDB\ADUMP'
*.audit_trail='db'

###########################################
# Miscellaneous
###########################################
*.compatible='11.1.0.0.0'

###########################################
# File Configuration
###########################################
*.control_files='G:\CONVDB\CONTROLFILE\CONTROL01.CTL','G:\CONVDB\CONTROLFILE\CONTROL02.CTL','G:\CONVDB\CONTROLFILE\CONTROL03.CTL'

###########################################
# Cache and I/O
###########################################
*.db_block_size=8192
*.db_file_multiblock_read_count=16

###########################################
# Database Identification
###########################################
*.db_domain=''
*.db_name='CONVDB'

###########################################
# Objects and LOBs
###########################################
*.session_max_open_files=100

###########################################
# Optimizer
###########################################
*.hash_join_enabled=TRUE
*.query_rewrite_enabled=FALSE
*.star_transformation_enabled=FALSE

###########################################
# PL/SQL
###########################################
*.utl_file_dir=*

###########################################
# Parallel Executions
###########################################
*.parallel_adaptive_multi_user=FALSE
*.parallel_automatic_tuning=TRUE
*.parallel_execution_message_size=8192
*.parallel_max_servers=8
*.parallel_threads_per_cpu=8

*.db_recovery_file_dest='H:\CONVDB\flash_recovery_area'
*.db_recovery_file_dest_size=21474836480
*.diagnostic_dest='H:\CONVDB'

###########################################
# MTS
###########################################
*.dispatchers='(protocol=TCP)'

###########################################
# Archive
###########################################
*.log_archive_dest_1='LOCATION=H:\CONVDB\ARCHIVE\'
*.log_archive_format='ARC%S_%R.%T'
*.memory_target=2952790016

###########################################
# Cursors and Library Cache
###########################################
*.cursor_sharing=SIMILAR
*.open_cursors=500

###########################################
# Processes and Sessions
###########################################
*.processes=150

###########################################
# Redo Log and Recovery
###########################################
*.fast_start_mttr_target=900

###########################################
# Security and Auditing
###########################################
*.remote_login_passwordfile=EXCLUSIVE
*.remote_os_authent=TRUE

*.background_core_dump='partial'
*.core_dump_dest='G:\CONVDB\CDUMP'
*.max_dump_file_size=102400
*.shadow_core_dump=partial
*.shared_servers=1

###########################################
# System Managed Undo and Rollback Segments
###########################################
*.undo_management=AUTO
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'

*.job_queue_processes =10

local_listener="(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.234)(PORT=1521))"

###################################

request you all to help me on urgent basis .If you have already resolved this issue.

Thanks in advance.

Regards,
Lekhraj

Report message to a moderator

Re: ORA-04030 : Out of Process Memory [message #537166 is a reply to message #537163]

Tue, 27 December 2011 01:24

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted
 *Action:

This has nothing to do with Oracle parameters but with Windows parameters and memory.
Upgrade to a 64 bit system.

Regards
Michel

Report message to a moderator

Re: ORA-04030 : Out of Process Memory [message #537178 is a reply to message #537166]

Tue, 27 December 2011 03:06

lekhrajdeshmukh
Messages: 3
Registered: December 2011
Location: India

Junior Member

Dear Michel,

Thanks a lot for your response.Could you please tell me if there is any other alternative solution rather then o/s updation.

Is there any solution by which I can check the exact size for memory parameter in oracle.

Once again thanks for your prompt response.

regards,
Lekhraj

Report message to a moderator

Re: ORA-04030 : Out of Process Memory [message #537180 is a reply to message #537178]

Tue, 27 December 2011 03:14

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As I said, it DOES NOT depend on an Oracle, I repeat NO ORACLE parameter can be changed.
It is an OS issue.

The only thing you can change is to use less memory in your program.

Regards%
Michel

Report message to a moderator

Re: ORA-04030 : Out of Process Memory [message #537187 is a reply to message #537163]

Tue, 27 December 2011 03:29

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

If you don't want to change to 64bit Windows, you could (if I remember correctly) configure Win32 AWE and then use_indirect_data_buffers=true.

Report message to a moderator

Re: ORA-04030 : Out of Process Memory [message #537195 is a reply to message #537187]

Tue, 27 December 2011 04:13

lekhrajdeshmukh
Messages: 3
Registered: December 2011
Location: India

Junior Member

Dear Michel & John,

Thanks a lot for your reply.
Actually I have noticed one thing that i have configure 2.75 gb ofr memory_target parameter.As i got info from other site in 32 bit system we can use max 1.7 gb for oracle memory.So i have reconfigured memory_target to 1.5 GB after that is it working fine.

@John :- I will check this and get back to you.

Once again thanks a lot for your quick reply.

Regards,
Lekhraj

Report message to a moderator

Previous Topic:	Oracle Architecture
Next Topic:	Archival Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 18:39:11 CST 2025