| Oracle shared pool [message #62472] |
Fri, 23 July 2004 04:38 |
chanu
Messages: 1
Registered: July 2004
|
Junior Member |
|
|
There is a query that is using the rule based optimizer and gives this error ora-4031 ( cannot allocate memory and solution is "shared pool size had to be increased" ). Using oracle 8i.
If the same query is run with choose based optimizer, it runs fine. It does not give any error.
Does this mean that the rule based optimizer takes more shared pool memory than the query that uses choose based optimizer ? Is there any reference to this in the documentation or any web links ?
Appreciate any help on this.
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
