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

Home -> Community -> Mailing Lists -> Oracle-L -> Shared Pool Advisory

Shared Pool Advisory

From: Daniel W. Fink <Daniel.Fink_at_Sun.COM>
Date: Wed, 25 Aug 2004 07:16:08 -0600
Message-id: <412C9118.2070709@sun.com>


A coworker is doing some poking about in 9i and has a few questions about the shared pool. I have not worked with these issues, the docs are typical and he wants to hear the good, the bad and the ugly of how it 'really' works.

Do you have any thoughts about the "advisory statistics", and how they can help you determine a good shared pool size?

Is the information in v$shared_pool_advice any good?

As always, thanks in advance.

Daniel Fink



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Aug 25 2004 - 08:13:10 CDT

Original text of this message

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