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]

TABLE: DBSNMP.BSLN_STATISTICS

Object Details

Object Name:	BSLN_STATISTICS
Object Type:	TABLE
Owner:	DBSNMP
Subobject Name:
Status:	VALID

Metric Statistics for Baselines

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: BSLN_STATISTICS_PK1

METRIC_ID
COMPUTE_DATE
TIMEGROUP
BSLN_GUID

Indexes

Index	Type	Uniqueness	Tablespace	Column
BSLN_STATISTICS_PK1	NORMAL	UNIQUE	SYSTEM	METRIC_ID COMPUTE_DATE TIMEGROUP BSLN_GUID

Foreign Keys

Table		Foreign Table	Foreign Key Column
BSLN_STATISTICS		BSLN_BASELINES	BSLN_STATISTICS BSLN_GUID

Columns

Name	Datatype	Length	Mandatory
BSLN_GUID	RAW	(16)	Yes
METRIC_ID	NUMBER		Yes
COMPUTE_DATE	DATE		Yes
TIMEGROUPING	VARCHAR2	(2)	Yes
TIMEGROUP	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
PCTILE_99	NUMBER
EST_SAMPLE_COUNT	NUMBER
EST_SLOPE	NUMBER
EST_INTERCEPT	NUMBER
EST_FIT_QUALITY	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
,      METRIC_ID
,      COMPUTE_DATE
,      TIMEGROUPING
,      TIMEGROUP
,      SAMPLE_COUNT
,      AVERAGE
,      MINIMUM
,      MAXIMUM
,      SDEV
,      PCTILE_25
,      PCTILE_50
,      PCTILE_75
,      PCTILE_90
,      PCTILE_95
,      PCTILE_99
,      EST_SAMPLE_COUNT
,      EST_SLOPE
,      EST_INTERCEPT
,      EST_FIT_QUALITY
,      EST_PCTILE_999
,      EST_PCTILE_9999
FROM DBSNMP.BSLN_STATISTICS;

Dependencies

[top of page]

DBSNMP.BSLN_STATISTICS does not reference any database object

DBSNMP.BSLN_STATISTICS is referenced by following:

DBSNMP: BSLN - show dependent code; BSLN - show dependent code; BSLN_INTERNAL - show dependent code; BSLN_INTERNAL - show dependent code; MGMT_BSLN_STATISTICS