SAP ABAP Table ORA_DBA_TCOLUMNS (Oracle monitoring: Transparent table for table columns)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ORA_DBA_TCOLUMNS	Table Relationship Diagram
Short Description	Oracle monitoring: Transparent table for table columns

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DB_COLUMN	☑	ORA_COLUMN	ORA_CHAR_30	CHAR	30	0	Oracle monitoring: Oracle table column
2	DB_DATATYPE	☑	ORA_DATATYPE	ORA_CHAR_18	CHAR	18	0	Oracle monitoring: Column data type
3	DB_DATALENGTH	☑	ORA_DATALENGTH	ORA_CHAR_12	CHAR	12	0	Oracle monitoring: Data length
4	LAST_ANALYZED	☐	ORA_DATE	ORA_CHAR_12	CHAR	12	0	Oracle monitoring: Date
5	SAMPLE_SIZE	☐	ORA_SAMPLE	ORA_CHAR_18	CHAR	18	0	Oracle monitoring: Sample size
6	NUM_DISTINCT	☐	ORA_DISTINCT	ORA_CHAR_18	CHAR	18	0	Oracle_monitoring: Distinct values
7	DD_COLUMN	☐	ORA_COLUMN	ORA_CHAR_30	CHAR	30	0	Oracle monitoring: Oracle table column
8	DD_DATATYPE	☐	ORA_DATATYPE	ORA_CHAR_18	CHAR	18	0	Oracle monitoring: Column data type
9	DD_DATALENGTH	☐	ORA_DATALENGTH	ORA_CHAR_12	CHAR	12	0	Oracle monitoring: Data length
10	KEYFIELD	☐	ORA_DATATYPE	ORA_CHAR_18	CHAR	18	0	Oracle monitoring: Column data type

History

Last changed by/on	SAP	20070813
SAP Release Created in	710