Re: How to measure Oracle Database Performance?

Hi Pete,

I usually only mention that parameter for advanced users ;)

I particularly like the new 9i Rel 2 option for _RUN_FASTER for those times when unrealistic expectations are being demanded, _RUN_FASTER=YESTERDAY Cheers

Richard

Pete Sharman wrote:
>
> In article <3D5F8BAD.202F75E9_at_bigpond.com>, Richard says...
> >
> >Hi Max,
> >
> >Trust me Max, there is no single tip that will fast track learning all
> >that's required when it comes to database performance management and
> >tuning. There's no 'SELECT is_every_running_effectively FROM v$database'
> >nor is there a 'UPDATE database_performance set tuning_parameters =
> >'appropriate' where status = 'crap'. Because a valid answer to your
> >question requires 900 pages.
> >
> >I'm afraid what you'll have to do is borrow some books if you can't
> >afford to buy them, read the Oracle Concepts and Performance Tuning
> >manuals (which are free), play and experiment on a real database (which
> >you can download for free), get work experience, attend a few courses,
> >and after a period of time, you'll get a hang on what's required.
> >
> >If a single tip is what you're after, I'll give you a single tip on how
> >to measure the performance of your database. Assuming you're the DBA,
> >how often does your phone ring with users complaining that everything is
> >running too slowly and that they can't effectively do their work. If it
> >rings often, you have performance problems, if it doesn't ring, she's
> >fine.
> >
> >Cheers
> >
> >Richard
>
> But Richard, you've forgotten about that undocumented _RUN_FASTER=TRUE
> parameter! ;)
>
> Pete
> >
> >
> >
> >"M.a.x G.e.decke" wrote:
> >>
> >> Thanx very much for your fast reply. But I would really appreciate it, if
> >> somebody has a tip which saves me the 45 $ for the book. :-)
> >>
> >> max
> >>
> >> "Fraser McCallum" <fmcc_at_removetoemail_odbaguru.com> schrieb im Newsbeitrag
> >> news:oo579.7518$g9.25338_at_newsfeeds.bigpond.com...
> >> > max,
> >> >
> >> > I'd suggest getting hold of a copy of "Scaling Oracle8i" by James Morle he
> >> > covers benchmarking very thoroughly in chapter 3 and the rest of the book
> >> is
> >> > well worth reading also!
> >> >
>
> HTH. Additions and corrections welcome.
>
> Pete
>
> SELECT standard_disclaimer, witty_remark FROM company_requirements;
Received on Mon Aug 19 2002 - 00:35:07 CDT