Re: ORA-04031 on query

From: <satar_at_my-dejanews.com>
Date: Sat, 07 Nov 1998 01:02:46 GMT
Message-ID: <72067m$3g0$1@nnrp1.dejanews.com>

See what happens if you comment out the "shared_pool_reserved_size" parameter. Maybe it's using only 5MB of the shared pool. This parameter controls the amount of SHARED_POOL_SIZE reserved for large allocations. Also make sure that the SHMAX setting in the etc/system is equal or greater than the total SGA. Satar

In article <hhK02.747$GK.2832534_at_news20.bellglobal.com>, "Rob" <forstr_at_tdbank.ca> wrote:
> shared_pool_size = 50,000,000
> shared_pool_reserved size = 5,000,000
> db_block_buffers = 25,000
> db_block_size = 8K
>
> I've been increasing this value steadily, but these queries always bomb. The
> query is going through an ODBC connection so there's some overhead there.
> Is there a configurable (upper) limit to the user's memory area (UGA) within
> the SGA?
> We have a large buffer cache to facilitate nightly data loads. See below:
>
> SVRMGR> show sga
> Total System Global Area 264120612 bytes
> Fixed Size 38988 bytes
> Variable Size 58757336 bytes
> Database Buffers 204800000 bytes
> Redo Buffers 524288 bytes
> Thanks,
> Rob.
>
> <SNIP>
> >>
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 06 1998 - 19:02:46 CST