BDNA Discover Publish version 7.7.1 with 201612 Sequence
BDNA_ORADB_INSTANCES - Oracle DB Instances

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ORACLEINSTANCE_LABEL varchar2 256  √  null Oracle Instance Name
EDITION1 varchar2 256  √  null Database Edition
DATABASEDOMAIN varchar2 256  √  null Database Domain
VERSION1 varchar2 256  √  null Database Version
DATABASENAME varchar2 256  √  null Database Name
SERVICENAME varchar2 256  √  null Service Name
COMPATIBLEVERSION varchar2 256  √  null Compatible Version
PARTITIONINGAPPLIED number 22  √  null Partitioning Option Applied
PARTITIONINGENABLED number 22  √  null Partitioning Option Enabled
RACENABLED number 22  √  null Real Application Cluster Option Enabled
STARTDATE varchar2 4000  √  null Start Date
UPTIME1 number 22  √  null Database Up Time
TOTALBYTESALLOCATED number 22  √  null DB Total Bytes Allocated
TOTALBYTESUSED number 22  √  null DB Total Bytes Used
SESSIONSHIGHWATERMARK number 22  √  null Max. Concurrent Sessions Since Startup
NUMSESSIONS number 22  √  null Number of Concurrent Sessions
OPENCURSORS number 22  √  null Open Cursors
NUMACCOUNTS number 22  √  null Number of Accounts (created)
ORACLEDB_L3 char 1  √  null Oracle DB Level 3?
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNAORADBINSTAN R
Operating Systems Id
ORACLEINSTANCE_ID number 22
BDNA_ORADB_SCHEMAS.ORACLEINSTANCE_ID FKM1_BDNAORADBSCHEMA R
BDNA_ORADB_TS.ORACLEINSTANCE_ID FKM1_BDNA_ORADB_TS R
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM1_BDNAORADBINSTAN R
Oracle Instance Id
INVENTORY_ID number 22 -1
BDNA_ORADB_SCHEMAS.INVENTORY_ID FKM1_BDNAORADBSCHEMA R
BDNA_ORADB_TS.INVENTORY_ID FKM1_BDNA_ORADB_TS R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNAORADBINSTANCE_INVENTORY_ID R
BDNA_INV_CATALOG_MAP.INVENTORY_ID FKM1_BDNAORADBINSTAN R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNAORADBINSTAN R
Inventory Id

Analyzed at Fri Oct 21 21:10 PDT 2016

Indexes:
Column(s) Type Sort Constraint Name
ORACLEINSTANCE_ID + INVENTORY_ID Primary key Asc/Asc PK_BDNA_ORADB_INSTANCES

Close relationships  within of separation:
Confidential and Proprietary to BDNA