ORA-04031 SGA error !! HELP!!
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