Re: memory statistics
From: Svend Jensen <svend.jensen_at_Ssecret.dk>
Date: Tue, 30 Mar 2004 17:37:46 +0200
Message-ID: <40699447$0$224$edfadb0f_at_dread16.news.tele.dk>
Date: Tue, 30 Mar 2004 17:37:46 +0200
Message-ID: <40699447$0$224$edfadb0f_at_dread16.news.tele.dk>
Vissu wrote:
> Hi All,
>
> I want to get the memory and cpu statistics. I want to know how to
> size each memory segment (sga, shared pool etc). I want to pin point
> problems. How would I go about doing this ? Is it through
> timed_statistics flag & statspack report ? Should I turn the flag on,
> then take the report for that day and turn it off ? I also want to use
> db_cache_advice to get cache advice.
>
> Any other ideas are appreciated.
> Thanks,
>
> Vissu
Hi Vissu
Are you trying to fix something not broken or are you hit by the compulsive tuning disorder? :-))
rgds
/Svend
Received on Tue Mar 30 2004 - 17:37:46 CEST