Home » RDBMS Server » Server Administration » ORA-04030 : Out of Process Memory (Oracle,11g,Windows server 32 bit)
ORA-04030 : Out of Process Memory [message #537163] Tue, 27 December 2011 01:18 Go to next message
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
Re: ORA-04030 : Out of Process Memory [message #537166 is a reply to message #537163] Tue, 27 December 2011 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-04030 : Out of Process Memory [message #537178 is a reply to message #537166] Tue, 27 December 2011 03:06 Go to previous messageGo to next message
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
Re: ORA-04030 : Out of Process Memory [message #537180 is a reply to message #537178] Tue, 27 December 2011 03:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-04030 : Out of Process Memory [message #537187 is a reply to message #537163] Tue, 27 December 2011 03:29 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: ORA-04030 : Out of Process Memory [message #537195 is a reply to message #537187] Tue, 27 December 2011 04:13 Go to previous message
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
Previous Topic: Oracle Architecture
Next Topic: Archival Error
Goto Forum:
  


Current Time: Fri Mar 29 01:51:02 CDT 2024