ORA_DBA_TCOLUMNS - Oracle monitoring: Transparent table for table columns
Oracle monitoring: Transparent table for table columns information is stored in SAP table ORA_DBA_TCOLUMNS.
It is part of development package S_DBMON_ORA_COCKPIT in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "Database Monitor for Oracle in Cockpit Framework".
It is part of development package S_DBMON_ORA_COCKPIT in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "Database Monitor for Oracle in Cockpit Framework".
Fields for table ORA_DBA_TCOLUMNS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| DB_COLUMN | Oracle monitoring: Oracle table column | X | ORA_COLUMN | CHAR | 30 | |
| DB_DATATYPE | Oracle monitoring: Column data type | X | ORA_DATATYPE | CHAR | 18 | |
| DB_DATALENGTH | Oracle monitoring: Data length | X | ORA_DATALENGTH | CHAR | 12 | |
| LAST_ANALYZED | Oracle monitoring: Date | ORA_DATE | CHAR | 12 | ||
| SAMPLE_SIZE | Oracle monitoring: Sample size | ORA_SAMPLE | CHAR | 18 | ||
| NUM_DISTINCT | Oracle_monitoring: Distinct values | ORA_DISTINCT | CHAR | 18 | ||
| DD_COLUMN | Oracle monitoring: Oracle table column | ORA_COLUMN | CHAR | 30 | ||
| DD_DATATYPE | Oracle monitoring: Column data type | ORA_DATATYPE | CHAR | 18 | ||
| DD_DATALENGTH | Oracle monitoring: Data length | ORA_DATALENGTH | CHAR | 12 | ||
| KEYFIELD | Oracle monitoring: Column data type | ORA_DATATYPE | CHAR | 18 |