Hello, Oracle Oracle Admin! Happy New Year!

Oracle version 9.2.0.8.

ORA-04030: trying to allocate 258072 bytes (hash-join subh, kllcqas: kllsltba)

How to be ?!

More IBM OS AIX 6.1 Oracle 10gR2 RAC began to issue

ORA-04031: Unable to Allocate xxxx Bytes Shared Memory "Even After SHARED_POOL Is Increased During Upgrade to 10gR2

How to be ?!

Thank you in advance!

    1 answer 1

    In general, this can be anything down to a defect in Oracle itself. Just as a guess:

    • do not set the DB_KEEP_CACHE_SIZE parameter
    • enlarge PGA_AGGREGATE_TARGET
    • decrease SORT_AREA_SIZE , HASH_AREA_SIZE