Friday, October 25, 2013

oracle DB 11203 @AIX bug

issue:
ORA-04030: out of process memory when trying to allocate 168824 bytes (kkoutlCreatePh,logdef* : kkoabr)

this is the bug in 11203 enterprise edition
and we can avoid this error  by adding _paramater

A Query Fails With ORA-4030 On "kkoutlCreatePh,logdef* : kkoabr" (Doc ID 1474457.1)

ALTER SYSTEM SET "_b_tree_bitmap_plans"=false scope=spfile;

No comments:

Post a Comment