|
DECLARE
reason_id dbms_server_alert.REASON_ID_T := NULL;
db_name recent_resource_incarnations$.db_unique_name%TYPE := :db_unique_name;
inst_name recent_resource_incarnations$.instance_name%TYPE := :instance_name;
event_id NUMBER := :event_id;
event_time TIMESTAMP
WITH TIME ZONE := TO_TIMESTAMP(:event_time,
:timestamp_fmt,
'NLS_CALENDAR=''Gregorian''');
BEGIN
CASE :reason_name
WHEN 'DATABASE_UP' THEN
reason_id := dbms_server_alert.RSN_FAN_DATABASE_UP;
WHEN 'DATABASE_DOWN' THEN
reason_id := dbms_server_alert.RSN_FAN_DATABASE_DOWN;
WHEN 'INSTANCE_DOWN' THEN
reason_id := dbms_server_alert.RSN_FAN_INSTANCE_DOWN;
WHEN 'SERVICE_UP' THEN
reason_id := dbms_server_alert.RSN_FAN_SERVICE_UP;
WHEN 'SERVICE_DOWN' THEN
reason_id := dbms_server_alert
请问这个语句是什么??? 是告警阈值吗???? 一直在执行 可不可以杀掉这个进程????
|
|