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 |