Database Administration (MOSC)

MOSC Banner

in ORACLE 9.2.0.8 error ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kg

edited Apr 24, 2015 10:03AM in Database Administration (MOSC) 3 commentsAnswered

During execution of procedure i have this error:

ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu sessi,pmucalm coll)

I have win2003 with 4GB RAM

and RDBMS Oracle 9.2.0.8.0

this is my pamater in init

open_cursors = 800   

max_enabled_roles = 100               

db_file_multiblock_read_count = 8

db_block_buffers = 40000

shared_pool_size = 90000000

large_pool_size = 10000000

java_pool_size = 130485760

log_checkpoint_interval = 10000

log_checkpoint_timeout = 1800

pga_aggregate_target = 24000000

processes = 150

parallel_max_servers = 0

log_buffer = 32768

max_dump_file_size = 10240  # limit trace file size to 5M each

undo_management = AUTO

undo_retention = 10800

undo_tablespace = UNDOTBS1

undo_suppress_errors = TRUE

global_names = false

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center