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

TABLE: DBSNMP.BSLN_102_STATISTICS

Object Details
Object Name: BSLN_102_STATISTICS
Object Type: TABLE
Owner: DBSNMP
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: BSLN_STATISTICS_PK
  1. ColumnDATASOURCE_GUID
  2. ColumnCOMPUTE_DATE
  3. ColumnSUBINTERVAL_CODE
  4. ColumnBSLN_GUID
Indexes
Index Type Uniqueness Tablespace Column
BSLN_STATISTICS_PK NORMAL UNIQUE TablespaceSYSTEM ColumnDATASOURCE_GUID
ColumnCOMPUTE_DATE
ColumnSUBINTERVAL_CODE
ColumnBSLN_GUID
Foreign Keys
Table
Foreign Table Foreign Key Column
BSLN_102_STATISTICS BSLN_STATISTICS_FK1 TableBSLN_102_BASELINES BSLN_102_STATISTICS BSLN_GUID
BSLN_102_STATISTICS BSLN_STATISTICS_FK2 TableBSLN_102_DATASOURCES BSLN_102_STATISTICS DATASOURCE_GUID
Columns
Name Datatype Length Mandatory Comments
BSLN_GUID RAW (16) Yes
DATASOURCE_GUID RAW (16) Yes
COMPUTE_DATE DATE
Yes
SUBINTERVAL_CODE RAW (21) 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.BSLN_102_STATISTICS;

Dependencies

[top of page]

DBSNMP.BSLN_102_STATISTICS does not reference any database object

DBSNMP.BSLN_102_STATISTICS is not referenced by any database object