-- 表領域の警告・クリティカルしきい値を設定する
EXEC DBMS_SERVER_ALERT.SET_THRESHOLD(
  metrics_id => DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL,
  warning_operator => DBMS_SERVER_ALERT.OPERATOR_GE,
  warning_value => '80',
  critical_operator => DBMS_SERVER_ALERT.OPERATOR_GE,
  critical_value => '90',
  observation_period => 1,
  consecutive_occurrences => 1,
  instance_name => NULL,
  object_type => DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,
  object_name => 'USERS');

-- アラートログの場所を確認する
SHOW PARAMETER background_dump_dest;