OraFAQ Forum: Enterprise Manager » How frequently ALERT METRICS are collected/refreshed

Home » RDBMS Server » Enterprise Manager » How frequently ALERT METRICS are collected/refreshed

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How frequently ALERT METRICS are collected/refreshed [message #477869]

Tue, 05 October 2010 00:32

anwarmhscomsa
Messages: 8
Registered: September 2010

Junior Member

Hi everybody
I have created some views in one SCHEMA and made it invalid
by dropping it's base table

1) Thru some queries, on SQL, I checked it shows there are invalid objects.
2) But even though , I refreshed DBCONSOLE Home Page it doesn't show the invalid objects.
3) How frequently ALERT METRICS are collected/refreshed

Anyone's help in this is regard is greatly appreciated

Anwar

Report message to a moderator

Re: How frequently ALERT METRICS are collected/refreshed [message #478578 is a reply to message #477869]

Mon, 11 October 2010 00:26

babuknb
Messages: 1700
Registered: December 2005
Location: NJ

Senior Member

1. How many invalid object you have ?

2. In DB Console, Have you configured Owners Invalid or Total Invalid objects count metric?

3. I am not sure, as per my understating every one min it will collect

Babu

Report message to a moderator

Re: How frequently ALERT METRICS are collected/refreshed [message #478582 is a reply to message #478578]

Mon, 11 October 2010 01:08

anwarmhscomsa
Messages: 8
Registered: September 2010

Junior Member

Thankyou for your reply

1) I just created one EMP table and based on this table I created some views
2) Then I renamed the base table EMP
3) Through other scripts from SQL I can find that there are invalid objects
4) I set the invalid object count metric, in DBCONSOLE
5) It did'nt updated the alert data when I refreshed the dbconsole, after few hours it updated.
6) My question is how frequently it collects

Anwar

Report message to a moderator

Re: How frequently ALERT METRICS are collected/refreshed [message #478600 is a reply to message #478582]

Mon, 11 October 2010 04:21

babuknb
Messages: 1700
Registered: December 2005
Location: NJ

Senior Member

Ok, Let me analyze something

EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS Jobs running every one min from dba_jobs

SQL> //

SCHEMA_USER                    WHAT                                               INTERVAL
------------------------------ -------------------------------------------------- ------------------------------
SYSMAN                         EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS();       sysdate + 1 / (24 * 60)

EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS procedure calling another procedure to collect (EMD_COLLECTION.RUN_COLLECTIONS) metric every one min.

procedure code

PROCEDURE execute_em_dbms_job_procs
  IS
      v_proc_start_date DATE DEFAULT SYSDATE;
      l_start_timestmp  TIMESTAMP := SYSTIMESTAMP;
  BEGIN

    -- Collections proc
    BEGIN
      EMD_COLLECTION.RUN_COLLECTIONS();
    EXCEPTION
      WHEN OTHERS THEN
        NULL;
    END;



-- Collections job
      submit_dbms_job(jobNum, 'EMD_COLLECTION.RUN_COLLECTIONS();',
                      SYSDATE, 'sysdate + (1/(24*60))' );
      COMMIT;

So, Confirming you, It's collect every one minute only.

Thanks, Babu

Report message to a moderator

Re: How frequently ALERT METRICS are collected/refreshed [message #479397 is a reply to message #478600]

Sat, 16 October 2010 12:07

anwarmhscomsa
Messages: 8
Registered: September 2010

Junior Member

Solved the problem by
settg the interval ,every one minute in file

C:\oracle\product\10.2.0\db_1\sysman\admin\default_collection\database.xmlp
we can also set other intervals

*********************************************
<CollectionItem NAME="all_invalid_objects"> UPLOAD="NO">
<Schedule>
<IntervalSchedule INTERVAL="1" TIME_UNIT="Min"/>
</Schedule>
*******************************

Mohammed Anwar Hussain

Report message to a moderator