Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04031 on query

Re: ORA-04031 on query

From: Rob <forstr_at_tdbank.ca>
Date: Fri, 06 Nov 1998 21:57:33 GMT
Message-ID: <hhK02.747$GK.2832534@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 Fri Nov 06 1998 - 15:57:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US