Re: ORA-04031 SGA error !! HELP!!

fff_at_ddd.net wrote:
: In article <Pine.SUN.3.91.960226094556.2163G-100000_at_seatimes>, Steve Butler <sbut-is_at_seatimes.com> wrote:
: >
: >On 21 Feb 1996 root_at_.MISSING-HOST-NAME. wrote:
: >> ORA-04031 Unable to allocate 744 bytes of shared
: >> memory("unknown object","sga heap","library cache")>!
: >>
: >> How can I configure it to avoid above error ?
: >
: >Upgrade to the latest release when it comes out.
: >
: >In the meantime, you have the following options:
: >
: >1. Do an ALTER SYSTEM FLUSH SHARED_POOL;
: >or
: >2. SHUTDOWN and STARTUP the database;
: skiped

: Had the very same message
: >> >ORA-04031 Unable to allocate 744 bytes of shared
: >>> memory
: when mispelled CURRVAL as "CURVAL"
: Dave

The best thing to do is increase the size of your shared pool. You will need to modify your init.ora file and bounce the instance.

MRB

--


--------------------------------------------------------------------------------

Marty R. Boos                             Phone: (612) 519-4123
Database Administrator                    Fax  : (612) 519-4711
Fingerhut Companies, Inc.                 Email: marty.boos_at_seag.fingerhut.com
                                          Pager: 1-800-SKY-PAGE  PIN 70699
--------------------------------------------------------------------------------
~