Re: ORA-04031 on query

Try to reduce db_block_buffers to say 10,000 and try to give that to shared_pool_size. Query may be little slow but it won't crash.

raghuvir

Rob <forstr_at_tdbank.ca> wrote in article <hhK02.747$GK.2832534_at_news20.bellglobal.com>...
> 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>
> >>
>
>
>
Received on Sat Nov 07 1998 - 12:52:47 CST