Oracle BSLN
Version 21c

General Information
Library Note Morgan's Library Page Header
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 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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
BSLN_INTERNAL
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx