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
Dependencies
BSLN
DBA_HIST_BASELINE
DBMS_STANDARD
BSLN_BASELINES
DBA_HIST_BASELINE_METADATA
GV_$INSTANCE
BSLN_METRIC_DEFAULTS
DBA_HIST_DATABASE_INSTANCE
PLITBLM
BSLN_OBSERVATION_SET
DBA_HIST_SNAPSHOT
USER_JOBS
BSLN_OBSERVATION_T
DBA_HIST_SYSMETRIC_SUMMARY
V_$DATABASE
BSLN_STATISTICS
DBA_HIST_WR_CONTROL
V_$INSTANCE
BSLN_STATISTICS_SET
DBA_THRESHOLDS
V_$METRICNAME
BSLN_STATISTICS_T
DBMS_JOB
V_$PARAMETER
BSLN_THRESHOLD_PARAMS
DBMS_MANAGEMENT_PACKS
WRH$_SYSMETRIC_HISTORY
BSLN_TIMEGROUPS
DBMS_OUTPUT
WRH$_SYSMETRIC_SUMMARY
BSLN_VARIANCE_SET
DBMS_SERVER_ALERT
WRM$_BASELINE
BSLN_VARIANCE_T
Documented
No
Exceptions
Error Code
Reason
ORA-20106
Baseline not found
First Available
Not known
Security Model
Owned by DBSNMP with EXECUTE granted to the OEM_MONITOR role
bsln_internal.mes_tg(
baseline_id_in IN NUMBER,
timegrouping_in IN VARCHAR2,
compute_date_in IN DATE,
begin_snap_id_in IN NUMBER,
end_snap_id_in IN NUMBER,
instance_name_in IN VARCHAR2,
dbid_in IN NUMBER)
RETURN dbsnmp.bsln_statistics_set;
bsln_internal.mes_xx(
baseline_id_in IN NUMBER,
compute_date_in IN DATE,
begin_snap_id_in IN NUMBER,
end_snap_id_in IN NUMBER,
instance_name_in IN VARCHAR2,
dbid_in IN NUMBER)
RETURN dbsnmp.bsln_statistics_set;
bsln_internal.metric_signal_qualities(
reference_time_in IN DATE,
observations_in IN dbsnmp.bsln_observation_set,
statistics_in IN dbsnmp.bsln_statistics_set)
RETURN dbsnmp.bsln.signal_rectype;
bsln_internal.n_field(hour_of_week_in IN BINARY_INTEGER) RETURN VARCHAR2;
DECLARE
retVal VARCHAR2(10);
BEGIN
FOR i IN 0 .. 167 LOOP
IF MOD(i, 12) = 0 THEN
SELECT TO_CHAR(i) || '-' || dbsnmp.bsln_internal.n_field(i)
INTO retVal
FROM dual;
It appears the guid must be a specific guid and not just a random one
bsln_internal.set_all_thresholds(bsln_guid_in IN RAW);
exec dbsnmp.bsln_internal.set_all_thresholds(SYS_GUID());
BEGIN dbsnmp.bsln_internal.set_all_thresholds(SYS_GUID()); END;
*
ERROR at line 1:
ORA-20106: Baseline not found
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 454
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 178
ORA-06512: at line 1
Returns an integer value for the day of the week but with Saturday equal to 0 rather than 7
bsln_internal.std7(date_in IN DATE) RETURN BINARY_INTEGER;
DECLARE
tdate DATE;
x dbms_id;
y PLS_INTEGER;
z PLS_INTEGER;
BEGIN
FOR d IN 1..7 LOOP
tdate := TRUNC(SYSDATE)+d;
SELECT TO_CHAR(tdate, 'DAY'), TO_CHAR(tdate, 'D'), dbsnmp.bsln_internal.std7(tdate)
INTO x, y, z
FROM dual;
dbms_output.put_line(RPAD(x, 9, ' ') || ' - ' || 'y' || ' - ' || z);
END LOOP;
END;
/ SATURDAY - y - 0
SUNDAY - y - 1
MONDAY - y - 2
TUESDAY - y - 3
WEDNESDAY - y - 4
THURSDAY - y - 5
FRIDAY - y - 6
