ORA-04031 SGA error !! HELP!!

From: <root>
Date: 1996/02/21
Message-ID: <4gerer$m3c_at_hpbblb.bbn.hp.com>#1/1


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 |
+--------------------------------------------------------------------+
Received on Wed Feb 21 1996 - 00:00:00 CET

Original text of this message