Re: 3 Oracle values to see DB is OK or not

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Mon, 08 May 2006 13:52:01 GMT
Message-ID: <Xns97BD45DC9BE8Cianalvistahotmailcom@70.169.32.36>

"Uwe Schmidt" <uwe.schmidt_at_dataport.de> wrote in news:newscache$0l6yyi$vt3$1_at_www-neu.dzsh.de:

> Hy NG,
>
> for a management-view it would be nice to see a linux system with an
> oracle db by only 5 values.
> System: CPU idle time + memory
> Oracle: ???
>
> maybe 3 values to see weather you have a problem or not. I would say:
> 1) database open or not
> 2) buffer cache hitratio

At what value does it go from problem to not a problem? & why this value and not some other value?

> 3) buffer busy waits

At what value does it go from problem to not a problem? & why this value and not some other value? Received on Mon May 08 2006 - 08:52:01 CDT