Re: System Stats - MAXTHR and SLAVETHR

I also had the same question about the best way to collect stats. Will try your suggestion (apress). Thanks,
Deepak  

    On Friday, September 2, 2016 9:46 AM, Stefan Koehler <contact_at_soocs.de> wrote:  

 Hey Luis,
the problem with collecting workload statistics over several days (e.g. whole week in your case) is that averages computed over several days may be very misleading when the workload changes considerably over that same period of time.

I prefer the approach of Christian Antognini that he describes in his TOP book (http://www.apress.com/9781430257585) on page 197/198.

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> Luis Santos <lsantos_at_pobox.com> hat am 2. September 2016 um 15:46 geschrieben:
>
>  I ever been in doubt for how long should we collect system stats. The majority of our system don´t have an OLTP vs DSS period. So the common
> approach for collect system stats (and store the for later reuse) for OLTP and DSS periods sounds no reasonable to me.
> 
>  My current approach is collect for a full week period.
> 
>  Can others please add his/her experiences on this subject?
> 
>  --
>  Att
>  Luis Santos

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



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