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.
Purpose
Global Workload Management Alerts
This package is for definitions and FUNCTIONs shared by the dbms_gsm_pooladmin and dbms_gsm_cloudadmin packages on the GSM cloud catalog database, and for utility routines used by GSMCTL when administering the cloud.
AUTHID
DEFINER
Constants
Name
Data Type
Value
yellow_level
VARCHAR2(7)
'YELLOW'
red_level
VARCHAR2(4)
'RED'
cpu_threshold
VARCHAR2(4)
'CPU'
disk_threshold
VARCHAR2(5)
'DISK'
Data Types
-- formatted for readability
SQL> SELECT dbms_metadata.get_ddl('TYPE', 'ALERT_TYPE', 'SYS') FROM dual;
CREATE OR REPLACE NONEDITIONABLE TYPE "SYS"."ALERT_TYPE" AS OBJECT (
timestamp_originating IN TIMETAMP WITH TIME ZONE,
organization_id IN VARCHAR2(10),
component_id IN VARCHAR2(3),
message_id IN NUMBER,
hosting_client_id IN VARCHAR2(64),
message_type IN VARCHAR2(12),
message_group IN VARCHAR2(30),
message_level IN NUMBER,
host_id IN VARCHAR2(256),
host_nw_addr IN VARCHAR2(256),
module_id IN VARCHAR2(64),
process_id IN VARCHAR2(128),
user_id IN VARCHAR2(30),
upstream_component_id IN VARCHAR2(30),
downstream_component_id IN VARCHAR2(4),
execution_context_id IN VARCHAR2(128),
error_instance_id IN VARCHAR2(142),
reason_argument_count IN NUMBER,
reason_argument_1 IN VARCHAR2(513),
reason_argument_2 IN VARCHAR2(513),
reason_argument_3 IN VARCHAR2(513),
reason_argument_4 IN VARCHAR2(513),
reason_argument_5 IN VARCHAR2(513),
sequence_id IN NUMBER,
reason_id IN NUMBER,
object_owner IN VARCHAR2(30),
object_name IN VARCHAR2(513),
subobject_name IN VARCHAR2(30),
object_type IN VARCHAR2(30),
instance_name IN VARCHAR2(16),
instance_number IN NUMBER,
scope IN VARCHAR2(10),
advisor_name IN VARCHAR2(30),
metric_value IN NUMBER,
suggested_action_msg_id IN NUMBER,
action_argument_count IN NUMBER,
action_argument_1 IN VARCHAR2(30),
action_argument_2 IN VARCHAR2(30),
action_argument_3 IN VARCHAR2(30),
action_argument_4 IN VARCHAR2(30),
action_argument_5 IN VARCHAR2(30),
pdb_name IN VARCHAR2(128));
ALTER TYPE "SYS"."ALERT_TYPE" MODIFY ATTRIBUTE object_owner VARCHAR2(128) CASCADE;
Dependencies
ALERT_TYPE
DBMS_GSM_CLOUDADMIN
DBMS_GSM_POOLADMIN
DBMS_GSM_ALERT_LIB
DBMS_GSM_COMMON
DBMS_SERVER_ALERT
Documented
No
First Available
12.1
Security Model
Owned by GSMADIN_INTERNAL with EXECUTE granted to GDS_CATALOG_SELECT, GSMADMIN_ROLE, GSM_POOLADMIN_ROLE and GSMUSER_ROLE
dbms_gsm_alerts.post_alert(
reason_id IN dbms_server_alert.reason_id_t,
severity IN dbms_server_alert.severity_level_t,
object_name IN VARCHAR2,
instance_name IN VARCHAR2 DEFAULT NULL,
database_name IN VARCHAR2 DEFAULT NULL,
pool_name IN VARCHAR2 DEFAULT NULL,
region_name IN VARCHAR2 DEFAULT NULL,
resource_name IN VARCHAR2 DEFAULT NULL,
thresh_level IN VARCHAR2 DEFAULT NULL,
expect_card IN VARCHAR2 DEFAULT NULL,
current_card IN VARCHAR2 DEFAULT NULL);
-- This demo is intended to show valid syntax for using the package's
-- objects but does not return a value
dbms_gsm_alerts.post_threshold_hit(
instance_name IN VARCHAR2,
pool_name IN VARCHAR2,
region_name IN VARCHAR2,
resource_name IN VARCHAR2,
thresh_level IN VARCHAR2);