Database Administration (MOSC)

MOSC Banner

send sms as a notification when tablespace full is

edited Jul 4, 2016 4:18AM in Database Administration (MOSC) 5 commentsAnswered ✓

Hi,

how could I achieve that, to send SMS when a tablespace full is!

we have the following threshold:

begin

  DBMS_SERVER_ALERT.set_threshold(metrics_id              => DBMS_SERVER_ALERT.tablespace_pct_full,

                                  warning_operator        => DBMS_SERVER_ALERT.operator_ge,

                                  warning_value           => '90',

                                  critical_operator       => DBMS_SERVER_ALERT.OPERATOR_GE,

                                  critical_value          => '97',

                                  observation_period      => 1,

                                  consecutive_occurrences => 1,

                                  instance_name           => NULL,

                                  object_type             => DBMS_SERVER_ALERT.object_type_tablespace,

                                  object_name             => NULL);

end;

and we already have an OS Script which able to send SMS and Emails.

how can I do that in SQL ?

how can I do that in EM ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center