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

TABLE: DBSNMP.BSLN_BASELINES

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

Baselines Designated for Metric Statistics Calculation

Storage Details
Tablespace: TablespaceSYSTEM
PCT Free: 10
PCT Used: 40
Primary Key: BSLN_BASELINES_PK2
  1. ColumnBSLN_GUID
Unique Key: BSLN_BASELINES_UK2
  1. ColumnDBID
  2. ColumnINSTANCE_NAME
  3. ColumnBASELINE_ID
Indexes
Index Type Uniqueness Tablespace Column
BSLN_BASELINES_PK2 NORMAL UNIQUE TablespaceSYSTEM ColumnBSLN_GUID
BSLN_BASELINES_UK2 NORMAL UNIQUE TablespaceSYSTEM ColumnDBID
ColumnINSTANCE_NAME
ColumnBASELINE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableBSLN_STATISTICS BSLN_STATISTICS_FK BSLN_BASELINES BSLN_STATISTICS BSLN_GUID
TableBSLN_THRESHOLD_PARAMS BSLN_THRESHOLDS_FK BSLN_BASELINES BSLN_THRESHOLD_PARAMS BSLN_GUID
Columns
Name Datatype Length Mandatory Comments
DBID NUMBER
Yes
INSTANCE_NAME VARCHAR2 (16) Yes
BASELINE_ID NUMBER
Yes
BSLN_GUID RAW (16) Yes
TIMEGROUPING VARCHAR2 (2)
AUTO_TIMEGROUP VARCHAR2 (1) Yes
STATUS VARCHAR2 (16) Yes
LAST_COMPUTE_DATE DATE

Query Text

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


SELECT DBID
,      INSTANCE_NAME
,      BASELINE_ID
,      BSLN_GUID
,      TIMEGROUPING
,      AUTO_TIMEGROUP
,      STATUS
,      LAST_COMPUTE_DATE
FROM DBSNMP.BSLN_BASELINES;

Dependencies

[top of page]

DBSNMP.BSLN_BASELINES does not reference any database object

DBSNMP.BSLN_BASELINES is referenced by following:

SchemaDBSNMP
PL/SQL PackageBSLN - show dependent code
Package BodyBSLN - show dependent code
PL/SQL PackageBSLN_INTERNAL - show dependent code
Package BodyBSLN_INTERNAL - show dependent code
ViewMGMT_BSLN_BASELINES
ViewMGMT_BSLN_INTERVALS
ViewMGMT_BSLN_STATISTICS
ViewMGMT_BSLN_THRESHOLD_PARMS