Table Detail Report

DM_SQL_PERF_DTL



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_SQL_PERF_DTL
Definition: Detail data used by the CBO Implementer
Table Type: REFERENCE





Column Detail - DM_SQL_PERF_DTL


Column Name Type Null? Definition
BUFFER_GETS DOUBLE Y Oracle Buffer gets count
BUFFER_GETS_EXEC DOUBLE N ratio buffer gets/execution for this statement and this optimizer mode
CCL_OPT_MODE DOUBLE N Cerner Optimizer Mode
DM_SQL_ID DOUBLE N primary key, pull value from DM_CLINICAL_SEQ
DM_SQL_PERF_DTL_ID DOUBLE N data management SQL performance detail identifier
EXECUTIONS DOUBLE Y Oracle execution count
EXECUTIONS_SEC DOUBLE N ratio of executions per second
OPTIMIZER_MODE VARCHAR(40) N 'UNKNOWN', 'RULE','FIRST ROWS','CHOOSE'
PLAN_DATA_EXISTS_IND DOUBLE Y Indicates whether plan data exists.
PLAN_HASH_VALUE DOUBLE Y Oracle Plan Hash Value
ROWS_PROCESSED DOUBLE Y Oracle Rows Processed Count
TUNING_DT_TM DATETIME N last time we worked on this SQL
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_PERF_DTL




Parent Column in DM_SQL_PERF_DTL (PK) Child Table Name Child Column Name
Children: DM_SQL_PERF_DTL_ID DM_SQL_PERF_DTL_PLAN DM_SQL_PERF_DTL_ID


DM_SQL_PERF_DTL_PLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management SQL Performance Detail Plan
Definition: This tables stores SQL plan information for SQL statements from the Oracle V$SQL_PLAN view. All but the 3 id columns come straight from the V$SQL_PLAN view, with some slight renaming of columns to avoid Millennium naming standard violations.
Table Type: ACTIVITY





Column Detail - DM_SQL_PERF_DTL_PLAN


Column Name Type Null? Definition
ACCESS_PREDICATES VARCHAR(4000) Y The access predicates from the V$SQL_PLAN table.
BYTES DOUBLE Y The bytes column information from the V$SQL_PLAN table.
CARDINALITY DOUBLE Y The cardinality column information from the V$SQL_PLAN table.
COST DOUBLE Y The cost column information from the V$SQL_PLAN table.
CPU_COST DOUBLE Y The CPU Cost column information from the V$SQL_PLAN table.
DEPTH DOUBLE Y The depth column information from the V$SQL_PLAN table.
DISTRIBUTION VARCHAR(20) Y The distribution column information from the V$SQL_PLAN table.
DM_SQL_ID DOUBLE N This column relates this performance detail plan row to a specific Data Management SQL Performance row.
DM_SQL_PERF_DTL_ID DOUBLE N This column relates this performance detail plan row to a specific performance detail record.
DM_SQL_PERF_DTL_PLAN_ID DOUBLE N Uniquely identifies a Performance Detail Plan SQL statement.
FILTER_PREDICATES VARCHAR(4000) Y The filter predicates column information from the V$SQL_PLAN table.
IO_COST DOUBLE Y The IO Cost column information from the V$SQL_PLAN table.
OBJECT_IDENT DOUBLE Y The object_id column information from the V$SQL_PLAN table.
OBJECT_NAME VARCHAR(64) Y The object_name column information from the V$SQL_PLAN table.
OBJECT_NODE VARCHAR(10) Y The Object_Node column information from the V$SQL_PLAN table.
OBJECT_OWNER VARCHAR(30) Y The Object_Owner column information from the V$SQL_PLAN table.
OPERATION VARCHAR(30) Y The operation column information from the V$SQL_PLAN table.
OPTIMIZER VARCHAR(20) Y The optimizer column information from the V$SQL_PLAN table.
OPTIONS VARCHAR(30) Y The options column information from the V$SQL_PLAN table.
OTHER VARCHAR(4000) Y The Other column information from the V$SQL_PLAN table.
OTHER_TAG VARCHAR(35) Y The Other Tag column information from the V$SQL_PLAN table.
PARENT_IDENT DOUBLE Y The Parent_ID column information from the V$SQL_PLAN table.
POSITION DOUBLE Y The position column information from the V$SQL_PLAN table.
SEARCH_COLUMNS DOUBLE Y The Search_Columns column information from the V$SQL_PLAN table.
TEMP_SPACE DOUBLE Y The Temp_Space column information from the V$SQL_PLAN table.
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.
VSQL_PLAN_IDENT DOUBLE N The VSQL_PLAN_ID column information from the V$SQL_PLAN table.



Relationship Detail - DM_SQL_PERF_DTL_PLAN


Child Column in DM_SQL_PERF_DTL_PLAN(FK) Parent Table Name Parent Column Name
Parents: DM_SQL_ID DM_SQL_PERFORMANCE DM_SQL_ID
DM_SQL_PERF_DTL_ID DM_SQL_PERF_DTL DM_SQL_PERF_DTL_ID


DM_SQL_PERF_MASTER



Column Section Top of Page


Table-level Detail

Description: DM SQL PERF MASTER
Definition: Data used by the DBO Optimizer
Table Type: ACTIVITY





Column Detail - DM_SQL_PERF_MASTER


Column Name Type Null? Definition
CCL_QUERY_NBR DOUBLE N Cerner Query Number
CCL_SCRIPT_NAME VARCHAR(30) N Cerner Script Name
COMMENTS VARCHAR(2000) Y Cerner Comments
DM_SQL_PERF_MASTER_ID DOUBLE N PRIMARY KEY
LAST_CHANGE_DT_TM DATETIME Y Last Change Date and Time
TGT_OPT_MODE DOUBLE N Cerner Optimizer Mode
TUNING_STATUS VARCHAR(40) Y 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_PERF_SCRIPT_VERSION



Column Section Top of Page


Table-level Detail

Description: DM SQL PERF SCRIPT VERSION
Definition: Data used by the CBO implementer for Dictionary information
Table Type: ACTIVITY





Column Detail - DM_SQL_PERF_SCRIPT_VERSION


Column Name Type Null? Definition
LAST_DPROTECT_DT_TM DATETIME N Last known date time from dictionary
NEW_VERSION_DT_TM DATETIME N Date and time of when LAST_DPROTECT_DT_TM was last determined
SCRIPT_ID DOUBLE N PRIMARY KEY
SCRIPT_NAME VARCHAR(30) N Cerner Script Name
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_PERF_TEXT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_SQL_PERF_TEXT
Definition: Stores sql text for each query as it was executed in different optimizer modes
Table Type: REFERENCE





Column Detail - DM_SQL_PERF_TEXT


Column Name Type Null? Definition
DM_SQL_ID DOUBLE N FOREIGN KEY from DM_SQL_PERFORMANCE
DM_SQL_PERF_TEXT_ID DOUBLE N Primary key, pull value from DM_CLINICAL_SEQ
SQL_TEXT VARCHAR(65) N Sql text from V$sqltext
SQL_TEXT_SEQ DOUBLE N Numeric sequence of SQL text (same as PIECE on v$sqltext)
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_PERF_TEXT


Child Column in DM_SQL_PERF_TEXT(FK) Parent Table Name Parent Column Name
Parents: DM_SQL_ID DM_SQL_PERFORMANCE DM_SQL_ID