Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00604, ORA-04031

153055Apr 25 2003 — edited Apr 25 2003

How can I handle this error message?

ERROR:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","TRIGGER$","sga heap","state objects")
ORA-00604: error occured at recursive SQL levle1
ORA-04031: unable to allocate 4048 bytes of shred memory
("shared pool","unknown object","sga heap","state objects")

I changed shared_pool_size.
Initial shared_pool_size is 52428800
and I changed it to 1500000000.

Isn't 150M enough?
Should I have to set shared_pool_size to lager size?
Or is there any other way to fix this problem?

Oracle Version is 8.1.6.
Platform is SGI , IRIX 6.4.10+.

Please, help me.

Tanki

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2003

Added on Apr 25 2003

#general-database-discussions

1 comment

287 views