ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
dbms_space_alert.delete_from_alert_outstanding(
i_reason_id IN NUMBER,
i_object_id IN NUMBER,
i_subobject_id IN NUMBER,
i_internal_instance_number IN NUMBER,
i_con_id IN NUMBER,
o_owner OUT VARCHAR2,
o_object_name OUT VARCHAR2,
o_subobject_name OUT VARCHAR2,
o_sequence_id OUT NUMBER,
o_error_instance_id OUT VARCHAR2,
o_state_transition_number OUT NUMBER,
o_creation_time OUT TIMESTAMP,
o_pdb_name OUT VARCHAR2);
dbms_space_alert.insert_into_alert_history(
p_sequence_id IN NUMBER,
p_owner IN VARCHAR2,
p_object_name IN VARCHAR2,
p_subobject_name IN VARCHAR2,
p_reason_argument_1 IN VARCHAR2,
p_reason_argument_2 IN VARCHAR2,
p_reason_argument_3 IN VARCHAR2,
p_reason_argument_4 IN VARCHAR2,
p_reason_argument_5 IN VARCHAR2,
p_time_suggested IN TIMESTAMP,
p_creation_time IN TIMESTAMP,
p_action_argument_1 IN VARCHAR2,
p_action_argument_2 IN VARCHAR2,
p_action_argument_3 IN VARCHAR2,
p_action_argument_4 IN VARCHAR2,
p_action_argument_5 IN VARCHAR2,
p_message_level IN NUMBER,
p_hosting_client_id IN VARCHAR2,
p_process_id IN VARCHAR2,
p_host_id IN VARCHAR2,
p_host_nw_addr IN VARCHAR2,
p_instance_name IN VARCHAR2,
p_instance_number IN NUMBER,
p_user_id IN VARCHAR2,
p_execution_context_id IN VARCHAR2,
p_error_instance_id IN VARCHAR2,
p_resolution IN NUMBER,
p_metric_value IN NUMBER,
p_state_transition_number IN NUMBER,
p_reason_id IN NUMBER,
p_pdb_name IN VARCHAR2,
p_con_id IN NUMBER);
dbms_space_alert.insert_into_alert_outstanding (
p_object_id IN NUMBER,
p_subobject_id IN NUMBER,
p_internal_instance_number IN NUMBER,
p_owner IN VARCHAR2,
p_object_name IN VARCHAR2,
p_subobject_name IN VARCHAR2,
p_sequence_id IN NUMBER,
p_reason_argument_1 IN VARCHAR2,
p_reason_argument_2 IN VARCHAR2,
p_reason_argument_3 IN VARCHAR2,
p_reason_argument_4 IN VARCHAR2,
p_reason_argument_5 IN VARCHAR2,
p_time_suggested IN TIMESTAMP,
p_creation_time IN TIMESTAMP,
p_action_argument_1 IN VARCHAR2,
p_action_argument_2 IN VARCHAR2,
p_action_argument_3 IN VARCHAR2,
p_action_argument_4 IN VARCHAR2,
p_action_argument_5 IN VARCHAR2,
p_message_level IN NUMBER,
p_hosting_client_id IN VARCHAR2,
p_process_id IN VARCHAR2,
p_host_id IN VARCHAR2,
p_host_nw_addr IN VARCHAR2,
p_instance_name IN VARCHAR2,
p_instance_number IN NUMBER,
p_user_id IN VARCHAR2,
p_execution_context_id IN VARCHAR2,
p_error_instance_id IN VARCHAR2,
p_context IN RAW,
p_metric_value IN NUMBER,
p_reason_id IN NUMBER,
p_state_transition_number IN NUMBER,
p_pdb_name IN VARCHAR2,
p_con_id IN NUMBER) ;
TBD
UPDATE_ALERT_OUTSTANDING
dbms_space_alert.update_alert_outstanding (
i_reason_argument_1 IN VARCHAR2,
i_reason_argument_2 IN VARCHAR2,
i_reason_argument_3 IN VARCHAR2,
i_reason_argument_4 IN VARCHAR2,
i_reason_argument_5 IN VARCHAR2,
i_time_suggested IN TIMESTAMP,
i_action_argument_1 IN VARCHAR2,
i_action_argument_2 IN VARCHAR2,
i_action_argument_3 IN VARCHAR2,
i_action_argument_4 IN VARCHAR2,
i_action_argument_5 IN VARCHAR2,
i_message_level IN NUMBER,
i_hosting_client_id IN VARCHAR2,
i_process_id IN VARCHAR2,
i_host_id IN VARCHAR2,
i_host_nw_addr IN VARCHAR2,
i_instance_name IN VARCHAR2,
i_instance_number IN NUMBER,
i_user_id IN VARCHAR2,
i_execution_context_id IN VARCHAR2,
i_context IN RAW,
i_metric_value IN NUMBER,
i_reason_id IN NUMBER,
i_object_id IN NUMBER,
i_subobject_id IN NUMBER,
i_internal_instance_number IN NUMBER,
i_con_id IN NUMBER,
o_owner OUT VARCHAR2,
o_object_name OUT VARCHAR2,
o_subobject_name OUT VARCHAR2,
o_sequence_id OUT NUMBER,
o_error_instance_id OUT VARCHAR2,
o_state_transition_number OUT NUMBER,
o_creation_time OUT TIMESTAMP,
o_pdb_name OUT VARCHAR2) ;