Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Problems with huge shared_pool_size

Re: Problems with huge shared_pool_size

From: Ethan Post <post.ethan_at_gmail.com>
Date: Thu, 16 Feb 2006 09:23:28 -0600
Message-ID: <357b48a90602160723t2f1d0899nc3dbbeed11201c17@mail.gmail.com>


Based on information from Steve and other noted wait performance icons I frequently warn customers about the dangers of an oversized shared pool. Of course with each version of Oracle things change. Does anyone have any type of test scripts that demonstrate the problems of an oversized pool? If not I will pester Tom at Hotsos if I don't get an answer here. His latching related scripts regarding hard parses made the point quite clear on issues of scalability and not using bind variables.

On 2/15/06, Bobak, Mark <Mark.Bobak_at_il.proquest.com> wrote:
> First, get Steve Adams' book, Oracle 8i Internal Services. Read it
> thoroughly, particularly the shared pool section of Chapter 6: Memory.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 16 2006 - 09:23:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US