BDNA Discover Publish version 7.7.2 with 201708
BDNA_LMS_OVERVIEW - LMS Overview

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
GROUPP char 1  √  null Group
AGGREGATION_LEVEL char 1  √  null Aggregation Level
ORACLE_CSI char 1  √  null Oracle CSI
ORACLE_PRODUCT_CATEGORY char 9  √  null Oracle Product Category
PHYSICAL_MACHINE_ID varchar2 256  √  null Physical Id / Host Name
VIRTUAL_MACHINE_ID varchar2 256  √  null Virtual Machine Id / Host Name
DATABASE_EDITION varchar2 256  √  null Database Edition
DATABASE_NAME varchar2 4000  √  null Database Name
DATABASE_VERSION varchar2 256  √  null Database Version
OPTIONS_INSTALLED varchar2 4000  √  null Options Installed
OPTIONS_IN_USE varchar2 4000  √  null Options In Use
PACKS_GRANTED varchar2 4000  √  null Packs Granted
PACKS_AGREED varchar2 4000  √  null Packs Agreed
APPLICATION_NAME char 1  √  null Application Name
APPLICATION_STATUS char 1  √  null Application Status (prod, test, dev, train..)
USER_COUNT_DB number 22  √  null User Count (DBA Users)
USER_COUNT_APP char 1  √  null User Count (Application)
SERVER_MANUFACTURER varchar2 256  √  null Server Manufacturer
SERVER_MODEL varchar2 512  √  null Server Model
TOTAL_PHYSICAL_CORES number 22  √  null Total Physical Cores
PROCESSOR_SPEED varchar2 44  √  null Processor Speed
SOCKET_CAPACITY_PHYSICAL char 1  √  null Socket Capacity Physical
TOTAL_LOGICAL_CORES number 22  √  null Total Logical Cores
PARTITIONING_METHODS char 17  √  null Partitioning Methods
DATABASE_ROLE varchar2 4000  √  null Database Role
SERVER_NAME_IN_THE_CLUSTER char 1  √  null Server name in the Cluster
TOP_CONCURRENCY_TIMESTAMP char 1  √  null Top Concurrency Timestamp
SESSIONS char 1  √  null Sessions
INSTANCE_SESSIONS_HIGHWATER number 22  √  null Instance Sessions Highwater
INSTALL_DATE varchar2 4000  √  null Install Date
MEASUREMENT_COMMENT char 1  √  null Measurement Comment
ORACLEINSTANCE_ID number 22 Oracle Instance Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNALMSOVERVIEW0_INVENTORY_ID R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA