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