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

root wrote:

: Hi DBA's,
 

: I am just begining DBA(!!-) . I am getting this error
: when I am trying to do DML operation[
: 2000 SQL stmts I am executing one by one,
: commiting only each 16th SQL stmt].
 

: 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 ?
 

: I dont want to keep increase shared spool size even
: for small DB's.
 

: This info may be useful to u guys...
 

: RAM Memory Information:
: available: 122232 Kbytes
 

: Total System Global Area 15681812 bytes
: Fixed Size 47932 bytes
: Variable Size 7409112 bytes
: Database Buffers 8192000 bytes
: Redo Buffers 32768 bytes
 

:
: Shared spool area 6000000
: db_block_size 4096
: db_block_buffers 2000
:
: Respond to my email.
:
: THANKX IN ADVANCE.
 
: +--------------------------------------------------------------------+
: | V.N.Saravana Vijayan email: vijay_at_mercedes.bbn.hp.com |
: +--------------------------------------------------------------------+

If you don't want to increase the size of the shared pool you can try to pin your procedures or sql statements into the shared pool.

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
--------------------------------------------------------------------------------
~