OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle shared pool

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

�

Report message to a moderator

Previous Topic:	Reserved words, Special Characters, etc.
Next Topic:	how can i know tablespace is fragmented.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 05:41:58 CDT 2025