Why - ORA-04031: unable to allocate 740 bytes of shared memory

From: Leigh <lsatchell_at_geelongcity.vic.gov.au>
Date: 31 Jul 2001 02:39:17 -0700
Message-ID: <2603dc0c.0107310139.315ac321@posting.google.com>

Folks,

I keep getting this error on a batch job running in a third party application. I've extended the shared_pool_size (SGA) from 200MB to 300MB in size and I still get it after a similar length of time (i.e. 8-9hrs). Could there be another cause or this this error always attributable to the size of the SGA?? It's a 7.3.4 database. The db has an 8k block size and 4000 db_block_buffers. Any vague ideas on such limited info please???

SVRMGR> select * from v$sga;

NAME                 VALUE
-------------------- ----------
Fixed Size                39816
Variable Size         316176656
Database Buffers       32768000
Redo Buffers            5242880

Thanks, Leigh. Received on Tue Jul 31 2001 - 04:39:17 CDT