RE: Enetrprise Manager CPU Sampling and Mesurement

  • From: John Hallas <John.Hallas@xxxxxxxxxxxxxxxxxx>
  • To: "exriscer@xxxxxxxxx" <exriscer@xxxxxxxxx>, Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 Dec 2013 11:45:32 +0000

I understand that it samples every 5 minutes (ora at least  the agent sends 
data every 5 minutes )- might need to check on that

However the data is aggregated  after 7 days it is rolled into hour aggregates 
then after 31 days it is rolled into daily aggregates


select table_name, partitions_retained
from em_int_partitioned_tables
where table_name in 
('EM_METRIC_VALUES','EM_METRIC_VALUES_HOURLY','EM_METRIC_VALUES_DAILY');
TABLE_NAME                    PARTITIONS_RETAINED
-----------------------------                -------------------
EM_METRIC_VALUES                                      7
EM_METRIC_VALUES_HOURLY                                 32
EM_METRIC_VALUES_DAILY                        2


From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Ls Cheng
Sent: 12 November 2013 12:33
To: Oracle Mailinglist
Subject: Enetrprise Manager CPU Sampling and Mesurement

Hi all
Does anyone know how Enterprise Manager gather and store Host CPU statistics?
I am interetsed in knowing if the data stored is per minute to show the 24 
hours chart, weekly and monthly or the sampling rate is different to show 
different periods?
Thanks

--
LSC

______________________________________________________________________
Wm Morrison Supermarkets Plc is registered in England with number 358949. The 
registered office of the company is situated at Gain Lane, Bradford, West 
Yorkshire BD3 7DL. This email and any attachments are intended for the 
addressee(s) only and may be confidential. 

If you are not the intended recipient, please inform the sender by replying to 
the email that you have received in error and then destroy the email. 
If you are not the intended recipient, you must not use, disclose, copy or rely 
on the email or its attachments in any way. 

This email does not constitute a contract in writing for the purposes of the 
Law of Property (Miscellaneous Provisions) Act 1989.

Our Standard Terms and Conditions of Purchase, as may be amended from time to 
time, apply to any contract that we enter into. The current version of our 
Standard Terms and Conditions of Purchase is available at: 
http://www.morrisons.co.uk/gscop

Although we have taken steps to ensure the email and its attachments are 
virus-free, we cannot guarantee this or accept any responsibility, 
and it is the responsibility of recipients to carry out their own virus checks. 
______________________________________________________________________

Other related posts: