| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
