CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_HA_ALERTS_PRVT
Version 11.1
 
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;
 
Related Topics
DBMS_HA_ALERTS
RAC
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [251 users online]    © 2010 psoug.org