Message-Id: <10596.115123@fatcity.com>
From: Chuck Hamilton <chuck_hamilton@yahoo.com>
Date: Mon, 21 Aug 2000 10:33:02 -0700 (PDT)
Subject: What goes into shared pool reserved area?

--0-783368690-966879182=:20250
Content-Type: text/plain; charset=us-ascii


In 8.1.6 you still have the shared_pool_reserved_size parameter but not the old shared_pool_reserved_min_alloc paramter. How do you know/control what goes into the reserved area? I'm trying to use it to reduce fragmentation in the shared pool and prevent ora-4031 errors.

TIA





---------------------------------
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
--0-783368690-966879182=:20250
Content-Type: text/html; charset=us-ascii

<P>In 8.1.6 you still have the shared_pool_reserved_size parameter but not the old shared_pool_reserved_min_alloc paramter. How do you know/control what goes into the reserved area? I'm trying to use it to reduce fragmentation in the shared pool and prevent ora-4031 errors.</P>
<P>TIA</P><BR><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://mail.yahoo.com/">Yahoo! Mail</a> - Free email you can access from anywhere!
--0-783368690-966879182=:20250--