eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: DBSNMP.MGMT_BSLN_STATISTICS

Object Details

Object Name:	MGMT_BSLN_STATISTICS
Object Type:	VIEW
Owner:	DBSNMP
Subobject Name:
Status:	VALID

Database Metric Baseline Statistics (10.2)

[View Source]

Columns

Name	Datatype	Length	Mandatory
BSLN_GUID	RAW	(16)	Yes
DATASOURCE_GUID	RAW	(2000)
COMPUTE_DATE	DATE		Yes
SUBINTERVAL_CODE	VARCHAR2	(5)	Yes
SAMPLE_COUNT	NUMBER		Yes
AVERAGE	NUMBER
MINIMUM	NUMBER
MAXIMUM	NUMBER
SDEV	NUMBER
PCTILE_25	NUMBER
PCTILE_50	NUMBER
PCTILE_75	NUMBER
PCTILE_90	NUMBER
PCTILE_95	NUMBER
EST_SAMPLE_COUNT	NUMBER
EST_SLOPE	NUMBER
EST_INTERCEPT	NUMBER
EST_FIT_QUALITY	NUMBER
EST_PCTILE_99	NUMBER
EST_PCTILE_999	NUMBER
EST_PCTILE_9999	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BSLN_GUID
,      DATASOURCE_GUID
,      COMPUTE_DATE
,      SUBINTERVAL_CODE
,      SAMPLE_COUNT
,      AVERAGE
,      MINIMUM
,      MAXIMUM
,      SDEV
,      PCTILE_25
,      PCTILE_50
,      PCTILE_75
,      PCTILE_90
,      PCTILE_95
,      EST_SAMPLE_COUNT
,      EST_SLOPE
,      EST_INTERCEPT
,      EST_FIT_QUALITY
,      EST_PCTILE_99
,      EST_PCTILE_999
,      EST_PCTILE_9999
FROM DBSNMP.MGMT_BSLN_STATISTICS;

Dependencies

[top of page]

DBSNMP.MGMT_BSLN_STATISTICS references the following:

DBSNMP: BSLN - show dependent code; BSLN_BASELINES; BSLN_STATISTICS
PUBLIC: GV$INSTANCE

DBSNMP.MGMT_BSLN_STATISTICS is not referenced by any database object