ORA-04031: unable to allocate 64 bytes of shared memory (Microsoft OLE DB error -2147467259)
Posted on 2005-03-30
We are running a very large sql statement and getting this error from one of our databases.
Microsoft OLE DB Provider for ODBC Drivers : error -2147467259 [Microsoft][ODBC driver for Oracle][Oracle]ORA-04031: unable to allocate 64 bytes of shared memory ("shared pool", select distinct ...",sql area", "optdef : apanlg")
I think it is because the sql statement is so long. I'd like to know what needs to be done in order to allow the statement to run?
Is there any limit on the maximum length of and sql statement in Oracle?
The version of Oracle being used is 8.1.