Re: ORA-04031

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Mon, 03 May 2004 11:37:08 GMT
Message-ID: <E9qlc.9545$TT.8145@news-server.bigpond.net.au>

"Robert Wehofer" <thalion77_at_graffiti.net> wrote in message news:mOplc.651$O9.148_at_news.chello.at...
> Hello!
>
> What can I do against following error message in Oracle 8.1
>
> ORA-04031: Unable to assign 8704 bytes of the common storage ("large
> pool","unknown object","hash-join subh","kllcqas:kllsltba")
>
> Regards,
> Robert
>
>
>

Robert,

My suggestion would be to increase the size of the Large Pool by adjusting the value in the initialization parameter, LARGE_POOL_SIZE. You could verify this advice by referring to the "Error Messages" manual for 8.1.

Douglas Hawthorne Received on Mon May 03 2004 - 06:37:08 CDT