Re: How to measure Oracle Database Performance?

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 Sun Aug 18 2002 - 13:20:50 CDT