Home » RDBMS Server » Enterprise Manager » Oracle 10.2G - emailling events every minutes ?
Oracle 10.2G - emailling events every minutes ? [message #143596] Fri, 21 October 2005 02:56 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4571
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
Re: Oracle 10.2G - emailling events every minutes ? [message #143613 is a reply to message #143605] Fri, 21 October 2005 04:23 Go to previous message
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
Previous Topic: What is my Management Server name?
Next Topic: Oracle 10.2g - How can we change the language of EM ?
Goto Forum:
  


Current Time: Thu May 26 21:36:03 CDT 2022