Tim,
I don't know if it matters, but we faced the same error in 9x, and when we
set the hash_area_size to 1M, it went away. The exact error message for us
was
ORA-04031: unable to allocate 1126656 bytes of shared memory ("shared
pool","unknown object","hash-join subh","kllcqc:kllcqslt")
The 3rd parameter is "hash-join subh", so I think it pertains to hash joins.
For Barb, the third parameter is "cursor work he(ap)" so I wonder would it
pertain to hash_area_size at all?
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
Sent: Thursday, May 16, 2002 2:14 PM
To: Multiple recipients of list ORACLE-L
Thanks to the wonderful search capabilities that Steve Adams has installed
on his website at www.ixora.com.au, the following page has some more
information about the X$KSMLRU fixed-table
(http://www.zoftware.org/tuning/tune_shared_pool.html#fixed_table)...
I did an "advanced search" on MetaLink for "kllcqc", making sure to check
the checkbox for "Bug Database" -- quite a few bugs appeared (for what they
are worth). One of them (#2324210) is against 9.0.1.3 on Solaris, but the
error message looks remarkably like yours even so. Like you, they are using
MTS. They indicate that the settings for SORT_AREA_SIZE and HASH_AREA_SIZE
are too large for the Shared Pool, hence the ORA-04031. The solution is to
reduce SORT_AREA_SIZE and HASH_AREA_SIZE...
What are the settings for SORT_AREA_SIZE and HASH_AREA_SIZE here? Is it
possible that the users may be using ALTER SESSION SET to set their own
"custom" values for these parameters? I think this statement should appear
in the V$SQL or V$SQLAREA if they are using it. This would possibly explain
the sudden (and violent) onset of these symptoms...
*********************************************************************2
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
*********************************************************************2
