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 |