Home » RDBMS Server » Enterprise Manager » How frequently ALERT METRICS are collected/refreshed
How frequently ALERT METRICS are collected/refreshed [message #477869] Tue, 05 October 2010 00:32 Go to next message
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

Re: How frequently ALERT METRICS are collected/refreshed [message #478578 is a reply to message #477869] Mon, 11 October 2010 00:26 Go to previous messageGo to next message
babuknb
Messages: 1736
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
Re: How frequently ALERT METRICS are collected/refreshed [message #478582 is a reply to message #478578] Mon, 11 October 2010 01:08 Go to previous messageGo to next message
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
Re: How frequently ALERT METRICS are collected/refreshed [message #478600 is a reply to message #478582] Mon, 11 October 2010 04:21 Go to previous messageGo to next message
babuknb
Messages: 1736
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

Re: How frequently ALERT METRICS are collected/refreshed [message #479397 is a reply to message #478600] Sat, 16 October 2010 12:07 Go to previous messageGo to next message
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
Re: How frequently ALERT METRICS are collected/refreshed [message #479399 is a reply to message #479397] Sat, 16 October 2010 12:18 Go to previous messageGo to next message
anwarmhscomsa
Messages: 8
Registered: September 2010
Junior Member
After above setting we need to restart dbconsole
Re: How frequently ALERT METRICS are collected/refreshed [message #479440 is a reply to message #479399] Sun, 17 October 2010 01:57 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Appreciate. Thanks your feedback.

Babu
Previous Topic: Help to recover database.
Next Topic: Trouble in setting up EM
Goto Forum:
  


Current Time: Fri Mar 29 05:58:38 CDT 2024