Oracle 18cR3 DBMS_ADR

Oracle DBMS_ADR_INTERNAL Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

Purpose Utility package supporting the Automatic Diagnostic Repository and related incident reporting.

AUTHID DEFINER

Dependencies

ADR_HOME_T	ADR_LOG_MSG_ARGS_T	DBMS_ADR
ADR_INCIDENT_CORR_KEYS_T	ADR_LOG_MSG_ECID_T	DBMS_ADRI_LIB
ADR_INCIDENT_ERR_ARGS_T	ADR_LOG_MSG_ERRID_T	DBMS_ADR_APP
ADR_INCIDENT_FILES_T	ADR_LOG_MSG_SUPPL_ATTRS_T	DBMS_STANDARD
ADR_INCIDENT_INFO_T	ADR_LOG_MSG_T	DBMS_UTILITY
ADR_INCIDENT_T	ADR_MSG_TEMPLATE_T	PLITBLM

Documented No

First Available 12.1.0

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvsadri.plb

Subprograms

CREATE_ADR_HOME	INCIDENT_CREATE	TEST_RESERVE_INCIDS
CREATE_INCIDENT	RESERVE_INCIDS	WRITE_LOG
GET_LOCATION	RUN_PURGE	WRITE_LOG_HANDLER
INCIDENT_ADD_METADATA	SET_TRACEFILE_IDENTIFIER	WRITE_TRACE

CREATE_ADR_HOME

Undocumented dbms_adr_internal.create_adr_home(home IN OUT adr_home_t);

TBD

CREATE_INCIDENT

Create an incident dbms_adr_internal.create_incident( problem_key IN VARCHAR2, error_facility IN VARCHAR2, error_number IN NUMBER, error_message IN VARCHAR2, error_args IN adr_incident_err_args_t, ecid IN VARCHAR2, signalling_component IN VARCHAR2, signalling_subcomponent IN VARCHAR2, suspect_component IN VARCHAR2, suspect_subcomponent IN VARCHAR2, correlation_keys IN adr_incident_corr_keys_t, files IN adr_incident_files_t, current_home IN adr_home_t) RETURN adr_incident_t;

TBD

GET_LOCATION

Retrieve an ADR directory disk location dbms_adr_internal.get_location( home IN OUT adr_home_t, adr_service IN VARCHAR2) RETURN VARCHAR2;

TBD

INCIDENT_ADD_METADATA

Add metadata to an existing incident dbms_adr_internal.incident_add_metadata(incident IN OUT adr_incident_t);

TBD

INCIDENT_CREATE

Undocumented dbms_adr_internal.incident_create( incident IN OUT adr_incident_t, data IN VARCHAR2);

TBD

RESERVE_INCIDS

Undocumented dbms_adr_internal.reserve_incids( home IN OUT adr_home_t, id_count IN BINARY_INTEGER) RETURN NUMBER;

TBD

RUN_PURGE

Undocumented dbms_adr_internal.run_purge( home IN sys.adr_home_t, threshold IN NUMBER);

TBD;

TEST_RESERVE_INCIDS

Undocumented dbms_adr_internal.test_reserve_incids;

exec dbms_adr_internal.test_reserve_incids;

      BEGIN dbms_adr_internal.test_reserve_incids; END;

      *

      ERROR at line 1:

      ORA-21560: argument ORA-21560: argument 2 is null, invalid, or out of range

      is null, invalid, or out of range

      ORA-06512: at "SYS.DBMS_ADR_INTERNAL", line 489

      ORA-06512: at line 1

SET_TRACEFILE_IDENTIFIER

An API for performing the action ALTER SESSION SET TRACEFILE_IDENTIFIER = '<identifier_string>'; dbms_adr_internal.set_tracefile_identifier( home IN OUT sys.adr_home_t, trc_identifier IN VARCHAR2);

TBD

WRITE_LOG

Write a string to the current ADR log file dbms_adr_internal.write_log( home IN OUT adr_home_t, log_msg IN adr_log_msg_t);

TBD

WRITE_LOG_HANDLER

Undocumented dbms_adr_internal.write_log_handler( msg_id IN VARCHAR2, msg_type IN NUMBER, msg_level IN NUMBER, msg_text IN VARCHAR2, timestamp_originating IN TIMESTAMP WITH TIME ZONE, timestamp_normalized IN TIMESTAMP WITH TIME ZONE, org_id IN VARCHAR2, component_id IN VARCHAR2, instance_id IN VARCHAR2, hosting_client_id IN VARCHAR2, msg_group IN VARCHAR2, host_id IN VARCHAR2, host_nwaddr IN VARCHAR2, module_id IN VARCHAR2, process_id IN VARCHAR2, thread_id IN VARCHAR2, user_id IN VARCHAR2, suppl_attrs IN adr_log_msg_suppl_attrs_t, problem_key IN VARCHAR2, upstream_comp_id IN VARCHAR2, downstream_comp_id IN VARCHAR2, ecid IN adr_log_msg_ecid_t, error_instance_id IN adr_log_msg_errid_t, msg_args IN adr_log_msg_args_t, detail_location IN VARCHAR2, suppl_detail IN VARCHAR2, msg_template_obj IN adr_msg_template_t, con_uid IN NUMBER DEFAULT NULL, con_id IN NUMBER DEFAULT NULL, con_name IN NUMBER DEFAULT NULL, current_home IN OUT adr_home_t);

TBD

WRITE_TRACE

Write trace lines to the trace file in the RDBMS ADR home dbms_adr_internal.write_trace( home IN sys.adr_home_t, trace_data IN VARCHAR2);

exec

 dbms_adr_internal.write_trace(???, 'Testing the new database version 12cR2');

      

      -- go to the directory returned by GET_TRACE_LOCATION function and open the most recent .trc files.>