Re: Relationship/correlation between events/stats ?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 15 Sep 2004 00:09:53 +1000
Message-ID: <4146fbb0$0$5727$afc38c87@news.optusnet.com.au>

Spendius wrote:

> Hi,
> Is there a paper or a page somewhere that would describe the
> likely links between events occuring in a DB and the statistics
> (kind of "when you encounter lots of log_file_sync you *should*
> see a high rate of user_commits in V$SYSSTAT"...) ?
> Insofar as both aspects can be related to one another of course...
>
> Thanks.
> Spendius

One of the best ways of getting that sort of thing is to beam up a Staspack report to www.oraperf.com. Not only does it provide pretty good tuning advice, it also explains the sorts of relationships you are after.

Regards
HJR Received on Tue Sep 14 2004 - 09:09:53 CDT