OraFAQ Forum: Enterprise Manager » Oracle 10.2G - emailling events every minutes ?

Home » RDBMS Server » Enterprise Manager » Oracle 10.2G - emailling events every minutes ?

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

Oracle 10.2G - emailling events every minutes ? [message #143596]

Fri, 21 October 2005 02:56

deadpoet
Messages: 17
Registered: August 2005

Junior Member

Oracle 10.2G
Em

dears,

We want to recieved events every minute via EM.
But it seems to program events every hour only ...
is there a solution ?

Thanx

[Updated on: Fri, 21 October 2005 03:01]

Report message to a moderator

Re: Oracle 10.2G - emailling events every minutes ? [message #143605 is a reply to message #143596]

Fri, 21 October 2005 03:45

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Hi,

I suspect that events are mailed out every time ADDM runs (after each AWR snapshot). Try to set this and let us know if it helps:

SQL> SELECT * FROM dba_hist_wr_control;

      DBID SNAP_INTERVAL        RETENTION            TOPNSQL
---------- -------------------- -------------------- ----------
 966815583 +00000 01:00:00.0    +00007 00:00:00.0    DEFAULT

SQL>
SQL> BEGIN
  2    DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(
  3          retention => 43200,
  4          interval  => 10
  5    );
  6  END;
  7  /

PL/SQL procedure successfully completed.

SQL>
SQL> SELECT * FROM dba_hist_wr_control;

      DBID SNAP_INTERVAL        RETENTION            TOPNSQL
---------- -------------------- -------------------- ----------
 966815583 +00000 00:10:00.0    +00030 00:00:00.0    DEFAULT

SQL>

BTW: Looks like the interval cannot go below 10 minutes.

Best regards.

Frank

Report message to a moderator

Re: Oracle 10.2G - emailling events every minutes ? [message #143613 is a reply to message #143605]

Fri, 21 October 2005 04:23

deadpoet
Messages: 17
Registered: August 2005

Junior Member

Hello Franck!

Thank you for your reply.

Sorry to say that I was already setup with an interval of 10 minutes for the snapshot.

I'm not sure , but I think that evens are not mailled when a snapshot is done. Because you can "FORCE" at every moment a snapshot via EM. So in this case I should have recieved a mail.

but it was not the case.

No I think that to mail an event, you must use the "preferences"
menu via EM. Create an event rule ( for example saying I want all for all) and then create a program that schedule the planning. (each week, day, or hour from a date to a date)

here is the link, where "megane2" is my computer's network ID

http://megane2:5500/em/console/pref/scheduleInfo?notDefined=false&userShown=SYSTEM&duration=8&oldSchedule=edit&startD ateField=21+oct.+2005&event=continue

Report message to a moderator

Previous Topic:	What is my Management Server name?
Next Topic:	Oracle 10.2g - How can we change the language of EM ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 16:26:34 CST 2024