Re: ORA-04031 SGA error !! HELP!!
Date: 1996/03/08
Message-ID: <4hpvo1$54l_at_news.mr.net>#1/1
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 -------------------------------------------------------------------------------- ~Received on Fri Mar 08 1996 - 00:00:00 CET