Table Detail Report

DM_SCRIPT_TABLES



Column Section Top of Page


Table-level Detail

Description: DM SCRIPT TABLES
Definition: Holds table names used in all parent/request & child objects
Table Type: ACTIVITY





Column Detail - DM_SCRIPT_TABLES


Column Name Type Null? Definition
SCHEMA_DATE DATETIME N Rev date from DM_SCHEMA_VERSION
SCRIPT_NAME VARCHAR(80) N The script name of the object that the table information was generated for
TABLE_NAME VARCHAR(32) N Name of the tables used within a specific object
USER_NAME VARCHAR(30) N Shows what user is accessing the table, either a BATCH or an individual user


DM_SEGMENTS



Column Section Top of Page


Table-level Detail

Description: DM SEGMENTS
Definition: Contains the same info as USER_SEGMENTS
Table Type: ACTIVITY





Column Detail - DM_SEGMENTS


Column Name Type Null? Definition
BLOCKS DOUBLE Y Number of blocks used by the segment
BYTES DOUBLE Y Number of bytes used by the segment
EXTENTS DOUBLE Y The number of extents used by the segment
FREELISTS DOUBLE Y Free lists for the segment
FREELIST_GROUPS DOUBLE Y Free list groups for the segment
INITIAL_EXTENT DOUBLE Y The initial extent allocated to the segment
MAX_EXTENTS DOUBLE Y The maximum extent allowed for the segment
MIN_EXTENTS DOUBLE Y The minimum extent for the segment
NEXT_EXTENT DOUBLE Y The next extent for the segment
PCT_INCREASE DOUBLE Y The percent increase for the segment
SEGMENT_NAME VARCHAR(81) N Name of the segment (index or table)
SEGMENT_TYPE VARCHAR(18) N The type of the segment
TABLESPACE_NAME VARCHAR(30) Y The name of the table space
TABLE_NAME VARCHAR(30) N The Table name associated with the segment (index or table)


DM_SOFT_CONSTRAINTS



Column Section Top of Page


Table-level Detail

Description: DM table for dynamic soft constraints.
Definition: DM merge table
Table Type: REFERENCE





Column Detail - DM_SOFT_CONSTRAINTS


Column Name Type Null? Definition
CHILD_COLUMN VARCHAR(30) Y Column name
CHILD_TABLE VARCHAR(30) Y Table name
CHILD_WHERE VARCHAR(255) Y Optional where clause
CODE_SET DOUBLE N code_set for the soft constraint
EXCLUDE_IND DOUBLE Y this constraint should be excluded
PARENT_COLUMN VARCHAR(30) Y Column name
PARENT_TABLE VARCHAR(30) Y Table name
REFERENCE_IND DOUBLE Y constraint is a reference type


DM_SQL_PERF



Column Section Top of Page


Table-level Detail

Description: DM SQL PERF
Definition: Data used by trhe CBO Implementer
Table Type: ACTIVITY





Column Detail - DM_SQL_PERF


Column Name Type Null? Definition
CCL_QUERY_NBR DOUBLE N Cerner Query Number
CCL_QUERY_NBR_TEXT VARCHAR(7) N Cerner query identifier
CCL_SCRIPT_NAME VARCHAR(30) N Cerner Script Name
COMMENTS VARCHAR(255) Y SQL PERF COMMENTS
DM_SQL_ID DOUBLE N PRIMARY KEY
LAST_TUNING_DT_TM DATETIME Y Last Tuning Date and Time
SQLTEXT_HASH_VALUE DOUBLE N Cerner generated hash value on SQL_TEXT from GV$SQL
TGT_OPT_MODE DOUBLE N Cerner Optimizer Mode
TUNING_STATUS VARCHAR(40) N Cerner tuning status
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


DM_SQL_PERFORMANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_SQL_PERFORMANCE
Definition: Stores tuning status, best optimizer mode for different queries used by Millennium applications.
Table Type: REFERENCE





Column Detail - DM_SQL_PERFORMANCE


Column Name Type Null? Definition
BEST_OPTIMIZER_MODE VARCHAR(40) N UNKNOWN', 'RULE', 'FIRST ROWS', 'CHOOSE'
COMMENTS VARCHAR(255) Y Contains comments relating to the performance of this SQL.
DM_SQL_ID DOUBLE N Primary key, pull value from DM_CLINICAL_SEQ
FINAL_BUFFER_GETS_EXEC DOUBLE N final ratio that was determined to be the best
FINAL_EXECUTIONS_SEC DOUBLE N final ratio of executions per second
FINAL_ROWS_PROCESSED_EXEC DOUBLE N Final number of rows processed executed
HASH_VALUE DOUBLE N Stores the hash value obtained from V$SQLAREA
INITIAL_BUFFER_GETS_EXEC DOUBLE N initial ratio that drove us to look at this statement
INITIAL_EXECUTIONS_SEC DOUBLE N initial ratio of executions per second
INITIAL_ROWS_PROCESSED_EXEC DOUBLE N Initial number of rows processed executed
LAST_TUNING_DT_TM DATETIME N last time we worked on this SQL
OUTLINE_NAME VARCHAR(40) Y name of the stored outline
TUNING_STATUS VARCHAR(40) N NOT TUNED, IN PROCESS, TUNED
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - DM_SQL_PERFORMANCE




Parent Column in DM_SQL_PERFORMANCE (PK) Child Table Name Child Column Name
Children: DM_SQL_ID DM_SQL_PERF_DTL_PLAN DM_SQL_ID
DM_SQL_PERF_TEXT DM_SQL_ID