Home » Infrastructure » Unix » Re: shared memory
Re: shared memory [message #97453] Wed, 15 May 2002 06:18
heidi schmidt
Messages: 1
Registered: May 2002
Junior Member
There are several factors that can come into play. For us we have a large MTS environment and our defaults for large_pool, large_pool_min_alloc, shared_pool_min_alloc were the Oracle set minimum. On metalink I found a great article on "Diagnosing and resolving the ora 04031 error" which helped me find this query
SELECT free_space, avg_free_size, used_space, avg_used_size, request_failures, last_failure_sizeFROM v$shared_pool_reserved

So I found out the req failure was larger than 0 and the last failure size was less than my shared_pool_min_alloc and that meant workign with the shared_pool but I also knew for MTS I need a larger large_pool so I will do both and watch the results with utlstats (we are still on 8.0.5)

Hope this helps. Heidi
Previous Topic: Cron()
Next Topic: Re: Problem with Oracle 8.1.7. installation
Goto Forum:

Current Time: Fri Jun 02 00:27:48 CDT 2023