Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04031 on query
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 bytesThanks,
<SNIP>
>>
Received on Fri Nov 06 1998 - 15:57:33 CST