orclz> execute DBMS_SERVER_ALERT.SET_THRESHOLD(-
>    metrics_id => DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL,-
>    warning_operator => DBMS_SERVER_ALERT.OPERATOR_GT,-
>    warning_value => '50',-
>    critical_operator => DBMS_SERVER_ALERT.OPERATOR_GT,-
>    critical_value => '75',-
>    observation_period => 1,-
>    consecutive_occurrences => 1,-
>    instance_name => NULL,-
>    object_type => DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,-
>    object_name => 'SMALL')

PL/SQL procedure successfully completed.

orclz> select OBSERVATION_PERIOD,CONSECUTIVE_OCCURRENCES from dba_thresholds where object_name='SMALL';

OBSERVATION_PERIOD CONSECUTIVE_OCCURRENCES
------------------ -----------------------
                 1                       1

orclz>

DECLARE
 warning_operator         BINARY_INTEGER;
 warning_value            VARCHAR2(60);
 critical_operator        BINARY_INTEGER; 
 critical_value           VARCHAR2(60);
 observation_period       BINARY_INTEGER;
 consecutive_occurrences  BINARY_INTEGER;
BEGIN
 DBMS_SERVER_ALERT.GET_THRESHOLD(
 DBMS_SERVER_ALERT.CPU_TIME_PER_CALL, warning_operator, warning_value,
    critical_operator, critical_value, observation_period, 
    consecutive_occurrences, 'inst1',
 DBMS_SERVER_ALERT.OBJECT_TYPE_SERVICE, 'main.regress.rdbms.dev.us.oracle.com');
 DBMS_OUTPUT.PUT_LINE('Warning operator:       ' || warning_operator);
 DBMS_OUTPUT.PUT_LINE('Warning value:          ' || warning_value);
 DBMS_OUTPUT.PUT_LINE('Critical operator:      ' || critical_operator);
 DBMS_OUTPUT.PUT_LINE('Critical value:         ' || critical_value);     
 DBMS_OUTPUT.PUT_LINE('Observation_period:     ' || observation_period);
 DBMS_OUTPUT.PUT_LINE('Consecutive occurrences:' || consecutive_occurrences);
END;
/