SGA Help......

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")>!

      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
      
     
     THANKX IN ADVANCE.



+--------------------------------------------------------------------+

| V.N.Saravana Vijayan           email:    vijay_at_mercedes.bbn.hp.com |    


+--------------------------------------------------------------------+