Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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) ;