Re: dbms_shared_pool.keep

From: Mladen Gogala <>
Date: Sat, 16 May 2009 13:02:41 +0000 (UTC)
Message-ID: <gumdhg$usl$>

On Fri, 15 May 2009 17:01:09 -0700, johnbhurley wrote:

> What's wrong exactly with pinning important packages if you have enough
> memory?

That was my question. The article that I remembered compared keeping procedures in the shared pool to setting the sticky bit. The argument was rather philosophical in nature, but I don't remember it. Sticky bit, as we all know, is obsolete. On Linux, there is a "readahead" package which does what setting the sticky bit used to do, but the functionality of the sticky bit is definitely gone from Oracle*Solaris 10 and the latest version of HP-UX.

Received on Sat May 16 2009 - 08:02:41 CDT

Original text of this message