Oracle | BSLN

Oracle BSLN Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Performance Tuning Baseline Related Utilities

AUTHID DEFINER

Constants

Name	Data Type	Value
Category
K_CATEGORY_DEMAND	bsln_metric_defaults.category%TYPE	'DEMAND'
K_CATEGORY_PERFORMANCE	bsln_metric_defaults.category%TYPE	'PERFORMANCE'
K_CATEGORY_SHAPE	bsln_metric_defaults.category%TYPE	'SHAPE'
Fail Action
K_FAIL_ACTION_PRESERVE	fail_action_t	'PRESERVE'
K_FAIL_ACTION_UNSET	fail_action_t	'UNSET'
Flags
K_FALSE	INTEGER	0
K_TRUE	INTEGER	1
K_NO	VARCHAR2(1)	'N'
K_YES	VARCHAR2(1)	'Y'
Method
K_METHOD_PCTMAX	threshold_method_t	'PCTMAX'
K_METHOD_SIGLVL	threshold_method_t	'SIGLVL'
Score
K_SCORE_HIGHINC	NUMBER	5.0
K_SCORE_MAXIMUM	NUMBER	10.0
K_SCORE_MEDIUMEXC	NUMBER	0.0
Signal Level
K_SIGLVL_95	param_value_t	0.95
K_SIGLVL_99	param_value_t	0.99
K_SIGLVL_999	param_value_t	0.999
K_SIGLVL_9999	param_value_t	0.9999
Status
K_STATUS_ACTIVE	preferred_status_t	'ACTIVE'
K_STATUS_INACTIVE	preferred_status_t	'INACTIVE'
K_STATUS_NONPREFERRED	preferred_status_t	'NONPREFERRED'
K_STATUS_PREFERRED	preferred_status_t	'PREFERRED'
Time Group Field
K_TIMEGROUP_FIELD_DY	timegroup_field_t	'DY'
K_TIMEGROUP_FIELD_NT	timegroup_field_t	'NT'
K_TIMEGROUP_FIELD_WD	timegroup_field_t	'WD'
K_TIMEGROUP_FIELD_WE	timegroup_field_t	'WE'
K_TIMEGROUP_FIELD_XX	timegroup_field_t	'XX'
Time Grouping
K_TIMEGROUPING_HD	timegrouping_t	K_TIMEGROUPING_FIELD_H \|\| K_TIMEGROUPING_FIELD_D
K_TIMEGROUPING_HX	timegrouping_t	K_TIMEGROUPING_FIELD_H \|\| K_TIMEGROUPING_FIELD_X
K_TIMEGROUPING_HW	timegrouping_t	K_TIMEGROUPING_FIELD_H \|\| K_TIMEGROUPING_FIELD_W
K_TIMEGROUPING_ND	timegrouping_t	K_TIMEGROUPING_FIELD_N \|\| K_TIMEGROUPING_FIELD_D
K_TIMEGROUPING_NW	timegrouping_t	K_TIMEGROUPING_FIELD_N \|\| K_TIMEGROUPING_FIELD_W
K_TIMEGROUPING_NX	timegrouping_t	K_TIMEGROUPING_FIELD_N \|\| K_TIMEGROUPING_FIELD_X
K_TIMEGROUPING_XD	timegrouping_t	K_TIMEGROUPING_FIELD_X \|\| K_TIMEGROUPING_FIELD_D
K_TIMEGROUPING_XW	timegrouping_t	K_TIMEGROUPING_FIELD_X \|\| K_TIMEGROUPING_FIELD_W;
K_TIMEGROUPING_XX	timegrouping_t	K_TIMEGROUPING_FIELD_X \|\| K_TIMEGROUPING_FIELD_X;
Time Grouping Fields
K_TIMEGROUPING_FIELD_D	VARCHAR2(1)	'D'
K_TIMEGROUPING_FIELD_H	VARCHAR2(1)	'H'
K_TIMEGROUPING_FIELD_N	VARCHAR2(1)	'N'
K_TIMEGROUPING_FIELD_W	VARCHAR2(1)	'W'
K_TIMEGROUPING_FIELD_X	VARCHAR2(1)	'X'
Miscellaneous
ASSERTFAIL_C	INTEGER	-20999
K_DEFAULT_NUM_OCCURS	NUMBER	2
PKGNAME_C	VARCHAR2(20)	'BSLN'

Data Types SUBTYPE guid_t IS bsln_baselines.bsln_guid%TYPE; SUBTYPE timegroup_field_t IS bsln_timegroups.intraday%TYPE; SUBTYPE timegroup_t IS bsln_statistics.timegroup%TYPE; SUBTYPE timegrouping_t IS bsln_statistics.timegrouping%TYPE; SUBTYPE fail_action_t IS bsln_threshold_params.fail_action%TYPE; SUBTYPE threshold_method_t IS bsln_threshold_params.threshold_method%TYPE; SUBTYPE param_value_t IS bsln_threshold_params.critical_param%TYPE; SUBTYPE preferred_status_t IS bsln_metric_defaults.status%TYPE; TYPE signal_rectype IS RECORD ( bsln_guid guid_t, metric_id NUMBER, quality NUMBER); TYPE signal_cvtype isIS REF CURSOR RETURN signal_rectype;

Dependencies

BSLN_BASELINES	BSLN_STATISTICS_T	MGMT_BSLN_BASELINES
BSLN_INTERNAL	BSLN_THRESHOLD_PARAMS	MGMT_BSLN_DATASOURCES
BSLN_METRIC_DEFAULTS	BSLN_TIMEGROUPS	MGMT_BSLN_METRICS
BSLN_METRIC_SET	DBA_HIST_DATABASE_INSTANCE	MGMT_BSLN_STATISTICS
BSLN_METRIC_T	DBA_HIST_SNAPSHOT	MGMT_BSLN_THRESHOLD_PARMS
BSLN_OBSERVATION_SET	DBMS_CRYPTO	UTL_RAW
BSLN_OBSERVATION_T	DBMS_STANDARD	V_$INSTANCE
BSLN_STATISTICS	MGMT_BSLN	WRH$_SYSMETRIC_HISTORY
BSLN_STATISTICS_SET

Documented No

Exceptions

Error Code	Reason
ORA-20101	X_INVALID_BASELINE
ORA-20102	X_INVALID_INTERVAL
ORA-20104	X_INVALID_THRESHOLD_METHOD
ORA-20105	X_INVALID_METRIC
ORA-20106	X_BASELINE_NOT_FOUND
ORA-20108	X_NOT_SUPPORTED
ORA-20109	X_BSLNTHR_ERROR
ORA-20110	X_DEPRECATION_ERROR
ORA-20111	X_INVALID_TIMEGROUPING

First Available Not known

Pragmas PRAGMA EXCEPTION_INIT(INVALID_BASELINE, -20101);
PRAGMA EXCEPTION_INIT(INVALID_INTERVAL, -20102);
PRAGMA EXCEPTION_INIT(INVALID_THRESHOLD_METHOD, -20104);
PRAGMA EXCEPTION_INIT(INVALID_METRIC, -20105);
PRAGMA EXCEPTION_INIT(BASELINE_NOT_FOUND, -20106);
PRAGMA EXCEPTION_INIT(NOT_SUPPORTED, -20108);
PRAGMA EXCEPTION_INIT(BSLNTHR_ERROR, -20109);
PRAGMA EXCEPTION_INIT(DEPRECATION_ERROR, -20110);
PRAGMA EXCEPTION_INIT(INVALID_TIMEGROUPING, -20111);
PRAGMA EXCEPTION_INIT(ASSERTFAIL, -20999);

Security Model Owned by DBSNMP with EXECUTE granted to the OEM_MONITOR role

Source {ORACLE_HOME}/rdbms/admin/dbmsbsln.sql
{ORACLE_HOME}/rdbms/admin/prvtbsln.plb

Subprograms

ACTIVATE_BASELINE	DEREGISTER_DATASOURCE	SET_ALL_THRESHOLDS
BASELINE_GUID	DISABLE	SET_DEFAULT_TIMEGROUPING
COMPUTE_ALL_STATISTICS	DROP_BASELINE	SET_THRESHOLD_PARAMETERS
COMPUTE_STATISTICS	ENABLE	SUBINTERVAL_CODE
CREATE_BASELINE_STATIC	IS_ENABLED	TARGET_UID
DATASOURCE_GUID	METRIC_SIGNAL_QUALITIES	THIS_TARGET_UID
DATA_AND_MODEL_OK	METRIC_UID	TIMEGROUP
DEACTIVATE_BASELINE	MOVING_WINDOW_BASELINE_GUID	UNSET_THRESHOLD_PARAMETERS
DELETE_BSLN_JOBS	REGISTER_DATASOURCE	UPDATE_MOVING_WINDOW

ACTIVATE_BASELINE

Baseline Administrative Routine - Deprecated bsln.activate_baseline( name_in IN VARCHAR2, target_uid_in IN guid_t := NULL);

TBD

BASELINE_GUID

Baseline Utility Routine bsln.baseline_guid( baseline_id_in IN NUMBER, instance_name_in IN VARCHAR2 := NULL, dbid_in IN NUMBER := NULL) RETURN guid_t;

TBD

COMPUTE_ALL_STATISTICS

Operational automation hooks - Deprecated as of 11.1 bsln.compute_all_statistics;

TBD

COMPUTE_STATISTICS

Statistics computation and quality (of extrapolation) - Deprecated bsln.compute_statistics( bsln_name_in IN VARCHAR2, interval_begin_in IN DATE, interval_end_in IN DATE, subinterval_key_in IN timegrouping_t, target_uid_in IN guid_t := NULL), RETURN bsln_statistics_set;

TBD

CREATE_BASELINE_STATIC

Baseline Administrative Routine - Deprecated bsln.create_baseline_static( name_in IN VARCHAR2, interval_begin_in IN DATE, interval_end_in IN DATE, subinterval_key_in IN timegrouping_t, target_uid_in IN guid_t := NULL);

TBD

DATASOURCE_GUID

Baseline Utility Routine - Deprecated bsln.datasource_guid( target_uid_in IN guid_t, metric_uid_in IN guid_t, key_value_in IN VARCHAR2 := ' ') RETURN guid_t DETERMINISTIC;

TBD

DATA_AND_MODEL_OK

Statistics computation and quality (of extrapolation) bsln.data_and_model_ok( threshold_method_in IN threshold_method_t, threshold_param_in IN param_value_t, sample_count_in IN NUMBER, fit_quality_in IN NUMBER) RETURN INTEGER;

TBD

DEACTIVATE_BASELINE

Baseline Administrative Routine - Deprecated bsln.deactivate_baseline( name_in IN VARCHAR2, target_uid_in IN guid_t := NULL);

TBD

DELETE_BSLN_JOBS

Enable/disable API, deprecated as of 11.1 bsln.delete_bsln_jobs;

TBD

DEREGISTER_DATASOURCE

Baseline Administrative Routine - Deprecated bsln.deregister_datasource( dbid_in IN NUMBER, instance_num_in IN NUMBER, metric_id_in IN NUMBER);

TBD

DISABLE

Enable/disable API, deprecated as of 11.1 bsln.disable;

TBD

DROP_BASELINE

Baseline Administrative Routine - Deprecated bsln.drop_baseline( name_in IN VARCHAR2, target_uid_in IN guid_t := NULL);

TBD

ENABLE

Enable/disable API, deprecated as of 11.1 bsln.enable;

TBD

IS_ENABLE

Enable/disable API, deprecated as of 11.1 bsln.is_enable RETURN INTEGER;

TBD

METRIC_SIGNAL_QUALITIES

Metric quality as signal bsln.metric_signal_qualities( bsln_guid_in IN guid_t, metric_ids_in IN bsln_metric_set := NULL, reference_time_in IN DATE) RETURN signal_cvtype;

TBD

METRIC_UID

Baseline Utility Routine bsln.metric_uid(metric_id_in IN NUMBER) RETURN guid_t DETERMINISTIC;

SELECT dbsnmp.bsln.metric_uid(42)

      FROM dual;

      

      DBSNMP.BSLN.METRIC_UID(42)

      ---------------------------

      C12B

MOVING_WINDOW_BASELINE_GUID

Baseline Utility Routine bsln.moving_window_baseline_guid( instance_name_in IN VARCHAR2 := NULL, dbid_in IN NUMBER := NULL) RETURN guid_t;

TBD

REGISTER_DATASOURCE

Baseline Administrative Routine - Deprecated bsln.register_datasource( dbid_in IN NUMBER, instance_num_in IN NUMBER, metric_id_in IN NUMBER);

TBD

SET_ALL_THRESHOLDS

Operational automation hooks - Deprecated as of 11.1 bsln.set_all_thresholds;

TBD

SET_DEFAULT_TIMEGROUPING

Baseline Administrative Routine bsln.set_default_timegrouping( timegrouping_in IN timegrouping_t, instance_name_in IN VARCHAR2 := NULL, dbid_in IN NUMBER := NULL);

TBD

SET_THRESHOLD_PARAMETERS

Baseline Administrative Routine

Overload 1 bsln.set_threshold_parameters( bsln_guid_in IN guid_t, metric_id_in IN NUMBER, threshold_method_in IN threshold_method_t, warning_param_in IN param_value_t, critical_param_in IN param_value_t, num_occurs_in IN INTEGER := K_DEFAULT_NUM_OCCURS, fail_action_in IN fail_action_t := K_FAIL_ACTION_UNSET);

TBD

Deprecated

Overload 2 bsln.set_threshold_parameters( bsln_guid_in IN guid_t, ds_guid_in IN guid_t, threshold_method_in IN threshold_method_t, warning_param_in IN param_value_t, critical_param_in IN param_value_t, num_occurs_in IN INTEGER := K_DEFAULT_NUM_OCCURS, fail_action_in IN fail_action_t := K_FAIL_ACTION_UNSET);

TBD

SUBINTERVAL_CODE

Baseline Utility Routine - Deprecated bsln.subinterval_code( subinterval_key_in IN timegrouping_t, time_in IN DATE) RETURN timegroup_t;

TBD

TARGET_UID

Baseline Utility Routine

Overload 1 bsln.target_uid( dbid_in IN NUMBER, instance_num_in IN NUMBER) RETURN guid_t;

TBD

Overload 2 bsln.target_uid( dbid_in IN NUMBER, instance_name_in IN VARCHAR2) RETURN guid_t DETERMINISTIC;

TBD

THIS_TARGET_UID

Undocumented bsln.this_target_uid RETURN guid_t;

SELECT dbsnmp.bsln.this_target_uid

      FROM dual;

      

      THIS_TARGET_UID

      ---------------------------------

      92ED6CD4171D6EA0516374F810193D2D

TIMEGROUP

Baseline Utility Routine

Overload 1 bsln.timeGroup( timegrouping_in IN timegrouping_t, time_in IN DATE) RETURN timegroup_t;

TBD

Overload 2 bsln.timeGroup( timegrouping_in IN timegrouping_t, hour_of_week_in IN BINARY_INTEGER) RETURN timegroup_t;

TBD

UNSET_THRESHOLD_PARAMETERS

Baseline Administrative Routine bsln.unset_threshold_parameters( bsln_guid_in IN guid_t, metric_id_in IN NUMBER);

TBD

UPDATE_MOVING_WINDOW

Baseline Administrative Routine - Deprecated bsln.update_moving_window( interval_days_in IN NUMBER, subinterval_key_in IN timegrouping_t, target_uid_in IN guid_t := NULL);

TBD