Skip to Content
0
Apr 01, 2008 at 07:01 AM

ORA-12801and ORA-04030

299 Views

Hi,

in a BI 7.0 system on Windows 32 with Oracle 10.2.0.2 with patch 17 we can see in SM21 this errors:

Database error 12801 at EXE

> ORA-12801: error signaled in parallel query server

> P003#ORA-04030: out of process memory when trying to allocat

> 64528 bytes (sort subheap,sort key)

Database error 12801

Database error 4030 at EXE

> ORA-04030: out of process memory when trying to allocate

> 260028 bytes (qerbi subheap,kdibhn[] in kdibhopen)

Database error 4030

Database error 4030 at FET

> ORA-04030: out of process memory when trying to allocate

> 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)

Database error 4030

Database error 4030 at FET

> ORA-04030: out of process memory when trying to allocate

> 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)

Database error 4030

Database error 4030 at FET

> ORA-04030: out of process memory when trying to allocate

> 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)

Database error 4030

Database error 4030 at FET

> ORA-04030: out of process memory when trying to allocate

> 123404 bytes (QERHJ hash-joi,kllcqas:kllsltba)

Database error 4030

Have you got any advice for us ?

init<SID>.ora

*._B_TREE_BITMAP_PLANS=FLASE

*._ELIMINATE_COMMON_SUBEXPR=FLASE

*._fix_control='4728348:OFF'

*._in_memory_undo=FALSE

*._index_join_enabled=FALSE

*._optim_peek_user_binds=FALSE

*._optimizer_join_sel_sanity_check=TRUE

*._optimizer_mjc_enabled=FALSE

*._sort_elimination_cost_ratio=10

*._TABLE_LOOKUP_PREFETCH_SIZE=0

*.background_dump_dest='G:\oracle\SID\saptrace\background'

*.bitmap_merge_area_size=33554432

*.compatible='10.2.0'

*.control_file_record_keep_time=30

*.control_files='X:\oracle\SID\origlogA\cntrl\cntrlSID.dbf','W:\oracle\SID\sapdata1\system_1\cntrl\cntrlSID.dbf','K:\oracle\SID\saparch\cntrl\cntrlSID.dbf'

*.core_dump_dest='G:\oracle\SID\saptrace\background'

*.create_bitmap_area_size=33554432

*.db_block_size=8192

*.db_cache_size=1G

*.db_files=254

*.db_name='SID'

*.DB_WRITER_PROCESSES=4

*.dml_locks=4000

*.event='10191 trace name context forever,level 1','10027 trace name context forever, level 1','10028 trace name context forever, level 1','38068 trace name context forever, level 100','10162 trace name context forever, level 1','10629 trace name context forever, level 1','14532 trace name context forever, level 1','10183 trace name context forever, level 1','10191 trace name context forever, level 1','38087 trace name context forever, level 1'

*.fast_start_mttr_target=900

*.FILESYSTEMIO_OPTIONS='SETALL'

*.hash_area_size=20971520

*.java_pool_size=167772160

*.log_archive_dest='K:\oracle\SID\oraarch\SIDarch'

*.LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf'

*.LOG_BUFFER=1048576

*.log_checkpoint_interval=0

*.log_checkpoints_to_alert=TRUE

*.max_dump_file_size='20000'

*.open_cursors=800

*.parallel_execution_message_size=16384

*.parallel_max_servers=40

*.parallel_threads_per_cpu=1

*.pga_aggregate_target=4G

*.processes=230

*.query_rewrite_enabled='FALSE'

*.RECYCLEBIN='OFF'

*.remote_os_authent=TRUE

*.replication_dependency_tracking=FALSE

*.sessions=440

*.sga_max_size=1258291200

*.shared_pool_reserved_size=62914560

*.shared_pool_size=550M

*.sort_area_retained_size=0

*.sort_area_size=10485760

*.star_transformation_enabled='TRUE'

*.statistics_level='TYPICAL'

*.timed_statistics=TRUE

*.undo_management='AUTO'

*.undo_retention=86400

*.undo_tablespace='PSAPUNDO'

*.user_dump_dest='G:\oracle\SID\saptrace\usertrace'

*.workarea_size_policy='AUTO'

Regards.

Ganimede Dignan.