Shared Pool Advisory

  • From: "Daniel W. Fink" <Daniel.Fink@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 25 Aug 2004 07:16:08 -0600

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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  • » Shared Pool Advisory