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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 31 Jul 2001 12:06:12 +0100
Message-ID: <3b669126$0$8512$ed9e5944@reading.news.pipex.net>

you could try issuing
alter system flush shared pool;
immediateley before running the batch job.

It might also be worth contacting the vendor to see if they have a patch for the issue.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Legal disclaimer required by my employer
****************************************************************************
**
This email contains information intended for the addressee only.
 It may be confidential and may be the subject of legal and/or professional
privilege.
Any dissemination, distribution, copyright or use of this communication
without prior permission of the addressee is strictly prohibited.
****************************************************************************
**

"Leigh" <lsatchell_at_geelongcity.vic.gov.au> wrote in message
news:2603dc0c.0107310139.315ac321_at_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 - 06:06:12 CDT