Search Results moving_window_baseline_guid

Overview

The DBSNMP.BSLN package is the Baseline (BSLN) engine shipped with Oracle's Database Server Management Pack, part of the DBSNMP instrumentation layer that surfaces database health metrics into Enterprise Manager and, by extension, into Oracle E-Business Suite monitoring. Although it resides in the DBSNMP schema rather than in an EBS application schema, EBS 12.1.1 and 12.2.2 environments inherit it because the EBS database is a fully instrumented Oracle database under the same DBSNMP user. The package encapsulates the logic required to create, maintain, and evaluate statistical baselines against which database performance metrics are compared. Its central purpose is to record a "normal" operating profile for a target — defined across intraday, daily, weekly, or hourly/daily time dimensions — and then compare current metric samples against that profile to flag anomalies. The ETRM classifies the API as OTHER, reflecting that it is a database-supplied utility rather than an EBS application programming interface; nevertheless it is documented within the EBS technical reference repository because its symbols appear in EBS database inventories.

Key Procedures and Functions

The package exposes roughly thirty documented entry points, organized around target, metric, datasource, and baseline identity. Identity helpers such as TARGET_UID, THIS_TARGET_UID, METRIC_UID, DATASOURCE_GUID, and BASELINE_GUID resolve and return the surrogate identifiers used throughout the BSLN schema, allowing callers to reference targets and metrics without hard-coding numeric keys. Baseline lifecycle is handled by CREATE_BASELINE_STATIC (establish a fixed reference window), MOVING_WINDOW_BASELINE_GUID with UPDATE_MOVING_WINDOW (maintain a rolling comparison window), and DROP_BASELINE (remove a baseline definition). Activation state is managed by ACTIVATE_BASELINE and DEACTIVATE_BASELINE. Datasource registration is controlled by REGISTER_DATASOURCE and DEREGISTER_DATASOURCE. Time-slicing behavior is governed by TIMEGROUP, SUBINTERVAL_CODE, and SET_DEFAULT_TIMEGROUPING, which accept the documented timegrouping constants (XX, HX, XD, HD, XW, HW, NW, ND) built from the single-character field codes X, N, H, W, and D. Threshold behavior is set and cleared with SET_THRESHOLD_PARAMETERS and UNSET_THRESHOLD_PARAMETERS, using the documented fail_action_t, threshold_method_t, and param_value_t subtypes. Finally, ENABLE and DISABLE toggle baseline collection for a target or metric.

Tables Accessed

The package reads and writes the BSLN repository tables — BSLN_BASELINES (baseline definitions and GUIDs), BSLN_STATISTICS (captured statistic samples with timegroup and timegrouping attributes), BSLN_TIMEGROUPS (intraday calendar dimensions), BSLN_THRESHOLD_PARAMS (critical and warning thresholds, fail actions, and threshold methods), and BSLN_METRIC_DEFAULTS (preferred status defaults per metric). It also draws on the Automatic Workload Repository through DBA_HIST_DATABASE_INSTANCE and DBA_HIST_SNAPSHOT, which supply the instance identity and snapshot boundaries against which baselines are correlated. Cryptographic and encoding support is provided by DBMS_OBFUSCATION_TOOLKIT and UTL_RAW, used to generate and validate baseline GUIDs deterministically.

Usage Notes

DBSNMP.BSLN is not invoked from EBS forms, concurrent programs, or standard application flows. It is executed by the Oracle Enterprise Manager agent and by Oracle-scheduled database jobs that periodically refresh moving-window baselines and evaluate thresholds. In an EBS 12.1.1 or 12.2.2 environment, DBAs encounter the package when tuning database performance history, when extending monitoring to EBS-specific targets, or when diagnosing DBSNMP jobs that populate the BSLN tables. Custom code should treat it as read-only infrastructure: invoking lifecycle procedures such as CREATE_BASELINE_STATIC or SET_THRESHOLD_PARAMETERS outside the supported EM interface can desynchronize baseline state from the agent and is generally unsupported. Seven other packages reference BSLN symbols, confirming its role as a foundational service consumed by the broader DBSNMP metric stack.