| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmshae.sql |
| First Available |
10g |
| Dependencies |
| DBMS_HA_ALERT_LIB |
DBMS_SYS_ERROR |
| DBMS_PRVT_TRACE |
GV$INSTANCE |
| DBMS_SERVER_ALERT |
RECENT_RESOURCE_INCARNATIONS$ |
| DBMS_SERVER_ALERT_PRVT |
|
|
| Security Model |
No privileges granted by SYS |
| |
| CHECK_HA_RESOURCES |
| Undocumented |
dbms_ha_alerts_prvt.check_ha_resources
RETURN VARCHAR2
|
SELECT
dbms_ha_alerts_prvt.check_ha_resources
FROM dual; |
| |
| CLEAR_INSTANCE_RESOURCES |
| Undocumented |
dbms_ha_alerts_prvt.clear_instance_resources(
database_domain IN VARCHAR2,
database_unique_name IN VARCHAR2,
instance_name IN VARCHAR2,
event_time IN TIMESTAMP WITH TIME ZONE);
|
| TBD |
| |
| INSTANCE_STARTUP_TIMESTAMP_TZ |
Undocumented |
dbms_ha_alerts_prvt.instance_startup_timezone_tz(startup_time
IN DATE)
RETURN TIMESTAMP WITH TIME ZONE
|
set serveroutput on
DECLARE
sut gv$instance.startup_time%TYPE;
ret VARCHAR2(100);
BEGIN
SELECT startup_time
INTO sut
FROM gv$instance;
SELECT SYS_EXTRACT_UTC(dbms_ha_alerts_prvt.instance_startup_timestamp_tz(
sut))
INTO ret
FROM dual;
dbms_output.put_line(ret);
END;
/ |
| |
| POST_HA_ALERT |
Undocumented |
dbms_ha_alerts_prvt.post_ha_alert(
reason_id
IN dbms_server_alert.reason_id_t,
same_transaction IN BOOLEAN,
clear_old_alert IN BOOLEAN,
severity
IN dbms_server_alert.SEVERITY_LEVEL_T DEFAULT
dbms_server_alert.LEVEL_WARNING,
database_domain IN VARCHAR2 DEFAULT
SYS_CONTEXT('USERENV', 'DB_DOMAIN'),
database_unique_name IN VARCHAR2 DEFAULT NULL,
instance_name IN VARCHAR2
DEFAULT NULL,
service_name IN VARCHAR2
DEFAULT NULL,
host_name
IN VARCHAR2 DEFAULT NULL,
incarnation IN
VARCHAR2 DEFAULT NULL,
event_reason IN VARCHAR2,
event_time IN TIMESTAMP WITH TIME ZONE,
cardinality IN
BINARY_INTEGER DEFAULT NULL,
event_id
IN NUMBER DEFAULT NULL,
metric_value IN NUMBER
DEFAULT NULL,
timeout_seconds IN BINARY_INTEGER DEFAULT
NULL,
immediate_timeout IN BOOLEAN DEFAULT TRUE,
background_process IN BOOLEAN DEFAULT FALSE,
signal_interna IN BOOLEAN DEFAULT
TRUE,
duplicates_ok IN BOOLEAN)
DEFAULT FALSE;
|
| TBD |
| |
| POST_INSTANCE_UP |
| Undocumented |
dbms_ha_alerts_prvt.post_instance_up RETURN VARCHAR2
|
col post_instance_up
format a30
SELECT dbms_ha_alerts_prvt.post_instance_up
FROM dual;
|
