Table Detail Report

DM_SQL_PLAN



Column Section Top of Page


Table-level Detail

Description: DM SQL PLAN
Definition: Used to store the execution plan for sql statements captured by dm_sql_snapshot
Table Type: ACTIVITY





Column Detail - DM_SQL_PLAN


Column Name Type Null? Definition
BYTES DOUBLE Y used by the explain plan
CARDINALITY DOUBLE Y used by the explain plan
COST DOUBLE Y used by the explain plan
ID DOUBLE Y used by the explain plan
INDEX_COLUMNS VARCHAR(255) Y contains the column string for the index used
OBJECT_INSTANCE DOUBLE Y used by the explain plan
OBJECT_NAME VARCHAR(30) Y name of the table or index
OBJECT_NODE VARCHAR(128) Y used by the explain plan
OBJECT_OWNER VARCHAR(30) Y owner of the table or index
OBJECT_TYPE VARCHAR(30) Y table or index
OPERATION VARCHAR(30) Y used by the explain plan
OPTIMIZER VARCHAR(255) Y cost or rule optimizer
OPTIONS VARCHAR(30) Y used by the explain plan
OTHER LONGTEXT Y used by the explain plan
OTHER_TAG VARCHAR(255) Y used by the explain plan
PARENT_ID DOUBLE Y used by the explain plan
POSITION DOUBLE Y this is the order that this part of the plan occurred in
REMARKS VARCHAR(80) Y this is used by the explain plan
SEARCH_COLUMNS DOUBLE Y this is used by the explain plan
STATEMENT_ID VARCHAR(30) Y This is the unique identifier for this SQL statement
TIMESTAMP DATETIME Y this is used by the explain plan


DM_SQL_SNAPSHOT



Column Section Top of Page


Table-level Detail

Description: Used to analyze SQL statements
Definition: Used to perform analysis on the SQL statements found in the SGA pad
Table Type: ACTIVITY





Column Detail - DM_SQL_SNAPSHOT


Column Name Type Null? Definition
EXECUTIONS DOUBLE Y Number of times this statement was executed
FIRST_LOAD_TIME DATETIME Y first load time for this SQL
GETS_EXECUTIONS DOUBLE Y This is the ratio of soft_gets/execution
HARD_GETS DOUBLE Y Number of hard i/o buffer gets
PREV_SNAPSHOT_ID DOUBLE Y This is the snapshot id of the most recent snapshot with the same statement
SCRIPT_NAME VARCHAR(80) Y This is the name of the script
SNAPSHOT_DT_TM DATETIME Y This is the date and time that the snapshot occurred
SNAPSHOT_ID DOUBLE N This is the primary key
SOFT_GETS DOUBLE Y Soft i/o buffer gets
STMT LONGTEXT Y This is the text of the actual statement
STMT_HASH_VALUE DOUBLE N This is from the hash_value in the SQL_TEXT table
TEST_SEQUENCE DOUBLE Y Uniquely identifies this snapshot


DM_SQL_TEST_SEQUENCES



Column Section Top of Page


Table-level Detail

Description: DM SQL TEST SEQUENCES
Definition: This is where all test sequences are stored
Table Type: ACTIVITY





Column Detail - DM_SQL_TEST_SEQUENCES


Column Name Type Null? Definition
DESCRIPTION VARCHAR(80) Y description for the test_sequence
TEST_SEQUENCE DOUBLE N this is the test sequence
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
USER_NAME VARCHAR(30) Y this is the creator of the test sequence


DM_TABLES_DOC_LOCAL



Column Section Top of Page


Table-level Detail

Description: DM TABLES DOC LOCAL
Definition: Copy of the dm_tables_doc admin table
Table Type: REFERENCE





Column Detail - DM_TABLES_DOC_LOCAL


Column Name Type Null? Definition
BPR_MAX DOUBLE Y BPR_MAX
BPR_MEAN DOUBLE Y BPR_MEAN
BPR_MIN DOUBLE Y BPR_MIN
BPR_STD_DEV DOUBLE Y BPR_STD_DEV
BYTES_PER_ROW DOUBLE Y BYTES_PER_ROW
CORE_IND DOUBLE Y CORE_IND
DATA_MODEL_SECTION VARCHAR(80) Y DATA_MODEL_SECTION
DEFINITION VARCHAR(500) Y DEFINITION
DELETE_FLG DOUBLE Y DELETE_FLG
DESCRIPTION VARCHAR(80) Y DESCRIPTION
DROP_IND DOUBLE Y This column will be used mark tables for obsolete.
FREELIST_CNT DOUBLE Y freelist count
FULL_TABLE_NAME VARCHAR(30) Y Full Table Name
GROWTH_CRITERIA VARCHAR(255) Y GROWTH_CRITERIA
HUMAN_REQD_IND DOUBLE Y HUMAN_REQD_IND
INSERT_FLG DOUBLE Y INSERT_FLG
MERGEABLE_IND DOUBLE Y Mergeable Indicator
MERGE_ACTIVE_IND DOUBLE Y Merge Active Indicator
MERGE_DELETE_IND DOUBLE Y Merge Delete Indicator
MERGE_UI_QUERY VARCHAR(255) Y Merge UI Query
PCT_FREE DOUBLE Y PCT_FREE
PCT_USED DOUBLE Y PCT_USED
PRIMARY_DELETE_SCRIPT VARCHAR(200) Y PRIMARY_DELETE_SCRIPT
PRIMARY_INSERT_SCRIPT VARCHAR(200) Y PRIMARY_INSERT_SCRIPT
PRIMARY_UPDATE_SCRIPT VARCHAR(200) Y PRIMARY_UPDATE_SCRIPT
PURGE_EXCEPT_IND DOUBLE Y If set to 1, do not purge this table or any of its children after archiving an encounter.
READS_FLG DOUBLE Y READS_FLG
REFERENCE_IND DOUBLE Y REFERENCE_IND
SCHEMA_REFRESH_DT_TM DATETIME Y SCHEMA_REFRESH_DT_TM
SCHEMA_REFRESH_REQUEST_DT_TM DATETIME Y SCHEMA_REFRESH_REQUEST_DT_TM
STATIC_ROWS DOUBLE Y STATIC_ROWS
STATIC_SIZE_FLG DOUBLE Y STATIC_SIZE_FLG
SUFFIXED_TABLE_NAME VARCHAR(18) Y Suffixed Table Name
TABLE_NAME VARCHAR(30) N TABLE_NAME
TABLE_SUFFIX VARCHAR(4) N Table Suffix in Text form. Usually a 4 character number with leading zeros
UPDATE_FLG DOUBLE Y UPDATE_FLG
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_TABLE_TREE2



Column Section Top of Page


Table-level Detail

Description: DM TBALE TREE
Definition: SHOW HIERARCHY OF THE TABLES WITHIN DM SECTION
Table Type: ACTIVITY





Column Detail - DM_TABLE_TREE2


Column Name Type Null? Definition
DATA_MODEL_SECTION VARCHAR(80) Y DATA_MODEL_SECTION
PARENT_TABLE_NAME VARCHAR(30) Y PARENT TABLE NAME
SEQ DOUBLE Y SEQUENCE
TABLE_NAME VARCHAR(30) Y TABLE NAME
TREE_LEVEL DOUBLE Y TREE LEVEL