Mark D Powell wrote:
> On Jul 19, 1:00 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> Jeremy Smith wrote:
>>> I've read that some of the sys and system objects would benefit from
>>> being pinned to the keep pool. I think I have an active DB with over
>>> 600 IO pre sec. I know what most everyone will say, and I've been
>>> doing SQL tunning/application tunning, which is never ending. But
>>> wanted to focus on this subject pinning objects from sys or system.
>>> Thanks I look forward from reading this furom's thoughts, if you know
>>> of any objects that are good candidates for the keep pool, please
>>> include them in your responce.
>> Well here's what one person will say though I'm not sure it is quite
>> what you were looking forward to.
>>
>> Have you read any books on the subject, such as Cary Milsap's or
>> are you just randomly throwing stuff at the wall and hoping something
>> will stick. There is no justification for "never ending" tuning.
>>
>> Get a copy of Optimizing Oracle Performance / ISBN 0-59600-527-X and
>> don't do anything until you've read it at least twice. My impression
>> is that you are doing as much harm as good: Perhaps more.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
>>> I've read that some of the sys and system objects would benefit from
> being pinned to the keep pool. <<
>
> Read where? Being that Oracle maintaines several areas of the shared
> pool for control information (dictionary cache) and so on specifically
> what objects do you think need pinning? The only sys owned objects I
> have ever bothered to pin are some of the more heavily used sys owned
> packages which were listed in a support white paper on resolving
> ORA-04031 errors.
>
> -- Mark D Powell --
There is a wonderful monograph in "Oracle Insights Tales of the Oak
Table" titled "Compulsive Tuning Disorder" written by Gaja Krishna
Vaidyanatha. It should be mandatory reading for all DBAs.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 19 2007 - 20:21:19 CDT
