Re: Data Dictionary Hit Ratio - myth or fact?

It probably will recommend SSD, after all the people putting forward the money for the site are in the business of making solid state disks. However, it will not recommend SSD as the only the solution to problems, it will typically identify multiple items to look at, including memory settings, init.ora settings (cursor_sharing, optimizer_index_cost_adj), keep_pool settings, and pinning packages in the shared pool.

And by the way, if I could afford SSD for all my instances, not to mention my laptop, I would buy it. Even now, if I could convince the boss, I would look real hard at getting SSD for a few key tables, maybe 100G total. It would definitely help matters. The price/Gig per SSD is dropping quickly. I understand that at least in Japan, laptops with SSD instead of traditional spinning Hard drives are already available. Unfortunately, my budget doesnt extend to that type of laptop currently.

On Wed, Mar 19, 2008 at 1:42 PM, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:

> I predict that statspackanalyzer.com will tell you that your database
> will benefit from solid state disks.
>
>
>
> (Can anyone come up with a genuine (not faked) StatsPack report that
> DOESN'T recommend the purchase of SSDs?)
>
>
>
> -Mark
>
>
>
> *--
> Mark J. Bobak*
> *Senior Database Administrator, System & Product Technologies*
> ProQuest
> 789 E. Eisenhower, Parkway, P.O. Box 1346
> Ann Arbor MI 48106-1346
> +1.734.997.4059 or +1.800.521.0600 x 4059
> mark.bobak_at_il.proquest.com
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Andrew Kerber
> *Sent:* Wednesday, March 19, 2008 2:14 PM
> *To:* Jared Still
> *Cc:* anelson77388_at_gmail.com; Oracle-L Freelists
> *Subject:* Re: Data Dictionary Hit Ratio - myth or fact?
>
>
>
> You are assuming that Lewis is 100% accurate in everything he says and
> statspack analyzer isnt? Not necessarily a good assumption... At the very
> least, that article is over a year old, and according to the statspack
> analyzer site, its analysis is continually revised. I have never seen the
> particular phrasing he quotes, so I suspect it is no longer used in any
> case.
>
> Statspack analyzer is currently very good at identifying the number of
> soft v. hard parses, which is very important to know. I have used it
> several times, and found it accurate.
>
> On Wed, Mar 19, 2008 at 11:02 AM, Jared Still <jkstill_at_gmail.com> wrote:
>
>
>
> On Wed, Mar 19, 2008 at 5:57 AM, Andrew Kerber <andrew.kerber_at_gmail.com>
> wrote:
>
> You might want to pull an AWR or Statspack report and see what they show.
> Then you can run it through statspackanalyzer.com (you do have to sign up
> for some email), and it can tell you a lot about your instance.
>
>
>
>
>
> That would be of dubious value.
>
> See *http://tinyurl.com/2yca7f
>
> *
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l