Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SOS!!!....Process running out of memory.

SOS!!!....Process running out of memory.

From: Vinod Gopinath BMMI IS <vinodg_at_BMMI.com.bh>
Date: Sun, 3 Oct 2004 16:57:43 +0300
Message-ID: <C9239A40098E1B47815F48965A7D0BF11B20E9@BMMIXCH.BMMIHQ.Root.AD>


Hello,
I have oracle 8.1.6 on WinNT Patch 4 with 4 CPU's and 4 Gig ram. I feel I have tuned the db correctly. I am getting the error <<
ERROR:
ORA-04030: out of process memory when trying to allocate 4000012 bytes (session
heap,context version)
>>
and for the reference, this is my parameter file. <<
db_name = "cs3"

instance_name = cs3
service_names = cs3
db_block_size = 8192
control_files = ("d:\cs3\controlfiles\cs3ctl01.ctl",
                         "d:\cs3\controlfiles\cs3ctl02.ctl",
                         "d:\cs3\controlfiles\cs3ctl03.ctl")
db_files = 1024
max_enabled_roles = 30
db_file_multiblock_read_count = 128
large_pool_size = 26914560
java_pool_size = 20971520
remote_login_passwordfile = exclusive
os_authent_prefix = ""
processes = 1000
sessions = 1000
parallel_max_servers = 800
log_checkpoint_timeout = 0
audit_trail = true # if you want auditing max_dump_file_size = 10240 # limit trace file size to 5M each
# Uncommenting the line below will cause automatic archiving if
archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=D:\Oracle\oradata\cs3\archive"
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
# Global Naming -- enforce that a dblink has same name as the db it
connects to
global_names = false # Changed to false on 21-07-04 because of New Dips Server database link connectivity
oracle_trace_enable = true
oracle_trace_collection_name = ""
background_dump_dest = d:\cs3\bdumps\bdump
user_dump_dest = d:\cs3\bdumps\udump
job_queue_processes = 4
job_queue_interval = 60

open_links = 4
distributed_transactions = 10
# Commented as per Oracle Advice on 25-07-04
#mts_dispatchers =

"(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# mts_dispatchers =

"(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
# Commented as per Oracle Advice on 25-07-04
#mts_dispatchers = "(protocol=TCP)"

sort_area_size = 10857600
sort_area_retained_size = 5428800
utl_file_dir=*
optimizer_mode = CHOOSE
shared_pool_size = 1048556000
shared_pool_reserved_size = 104855600
rollback_segments = ( RBIG, R01, R02, R03, R04, R05, R06, R07, R08, R09, R10, R11, R12, R13, R14 )
timed_statistics = true
log_buffer = 52428800
log_checkpoint_interval = 10100
open_cursors = 1000000
db_block_buffers = 29972
DB_BLOCK_LRU_LATCHES = 24
Dml_Locks = 4000
session_cached_cursors = 10000
fast_start_io_target = 25600
# Earlier this was 8.1.5

compatible = 8.1.6
optimizer_index_caching = 20
optimizer_index_cost_adj = 90
>>
Can some one help me. Its urgent.
/- Vin
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Oct 03 2004 - 08:48:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US