ORA_DBA_TABLES is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of ORA_DBA_TABLES in SAP.
- Table description : Copy of DBA_TABLES (currently not provided with snapshots)
- Module : BC-CCM-MON-TUN
- Parent Module : BC
- Package : STUN
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP ORA_DBA_TABLES Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
SNAPSHOT_ID | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | ORA_SNAPSHOT_ID |
OWNER | Oracle monitoring: Owner of the object | ORA_OWNER_30 | ORA_CHAR_30 |
TABLE_NAME | Oracle monitoring: table name | ORA_TABLE_NAME | ORA_CHAR_30 |
TABLESPACE_NAME | Oracle monitoring: Tablespacename to which objects belong | ORA_TABLESPACE_NAME | ORA_CHAR_30 |
CLUSTER_NAME | Oracle monitoring: cluster name | ORA_CLUSTER_NAME | ORA_CHAR_30 |
IOT_NAME | Oracle monitoring: IOT name | ORA_IOT_NAME | ORA_CHAR_30 |
PCT_FREE | Oracle monitoring:percentage of free space in a block | ORA_PCT_FREE | ORA_NUM_22 |
PCT_USED | Oracle monitoring: percentage of used space in a block | ORA_PCT_USED | ORA_NUM_22 |
INI_TRANS | Oracle monitoring: Initial number of transactions | ORA_INI_TRANS | ORA_NUM_22 |
MAX_TRANS | Oracle monitoring: Maximum number of transactions | ORA_MAX_TRANS | ORA_NUM_22 |
INITIAL_EXTENT | Oracle monitoring: Size of the initial extent in bytes | ORA_INITIAL_EXTENT | ORA_NUM_22 |
NEXT_EXTENT | Oracle monitor: Next extent | ORA_NEXT_EXTENT | ORA_NUM_22 |
MIN_EXTENTS | Oracle monitor: Minimum extent | ORA_MIN_EXTENTS | ORA_NUM_22 |
MAX_EXTENTS | Oracle monitor: Maximum extent | ORA_MAX_EXTENTS | ORA_NUM_22 |
PCT_INCREASE | Oracle monitor. PCT increase | ORA_PCT_INCREASE | ORA_NUM_22 |
FREELISTS | Oracle monitoring: Number of process freelists allocated | ORA_FREELISTS | ORA_NUM_22 |
FREELIST_GROUPS | Oracle monitoring: Number of freelist groups allocated | ORA_FREELIST_GROUPS | ORA_NUM_22 |
LOGGING | Oracle monitoring: Logging attribute | ORA_LOGGINGA | ORA_CHAR_3 |
BACKED_UP | Oracle monitoring: Has table been backed up since last chang | ORA_BACKED_UP | ORA_CHAR_1 |
NUM_ROWS | Oracle monitoring: Number of rows in the table | ORA_NUM_ROWS | ORA_NUM_22 |
BLOCKS | Oracle monitoring: Number of used data blocks in the table | ORA_BLOCKS_USED | ORA_NUM_22 |
EMPTY_BLOCKS | Oracle monitoring: Number of empty (never used) data blocks | ORA_EMPTY_BLOCKS | ORA_NUM_22 |
AVG_SPACE | Oracle monitoring: avg. free space (bytes) in a data block | ORA_AVG_SPACE | ORA_NUM_22 |
CHAIN_CNT | Oracle monitoring: Number of rows in table that are chained | ORA_CHAIN_CNT | ORA_NUM_22 |
AVG_ROW_LEN | Oracle monitoring: Average length of a row in table (bytes) | ORA_AVG_ROW_LEN | ORA_NUM_22 |
AVG_SPACE_FREE | Oracle monitoring: avg. freespace of all blocks on freelist | ORA_AVG_SPACE_FREE | ORA_NUM_22 |
NUM_FREELIST_BLK | Oracle monitoring: number of blocks on the freelist | ORA_NUM_FREELIST_BLK | ORA_NUM_22 |
DEGREE | Oracle monitoring: number of threads per instance for scan | ORA_DEGREE | ORA_DEC_22 |
INSTANCES | Oracle monitoring:inst. across which table is to be scanned | ORA_INSTANCES | ORA_CHAR_10 |
CACHE | Oracle monitoring:Whether the cluster is to be cached in buf | ORA_CACHE_DBA | ORA_CHAR_5 |
TABLE_LOCK | Oracle monitoring: Whether table locking is enabled or disab | ORA_TABLE_LOCK | ORA_CHAR_8 |
SAMPLE_SIZE | Oracle monitoring: Sample size used in analyzing this table | ORA_SAMPLE_SIZE | ORA_NUM_22 |
LAST_ANALYZED_D | Oracle monitoring: Date of last table analysis (date field) | ORA_LAST_ANALYZED_D | ORA_DATE |
LAST_ANALYZED_T | Oracle monitoring: Date of last table analysis (time field) | ORA_LAST_ANALYZED_T | ORA_TIME |
PARTITIONED | Oracle monitoring: Indicates whether table is partitioned | ORA_PARTITIONED | ORA_CHAR_3 |
IOT_TYPE | Oracle monitoring: IOT type | ORA_IOT_TYPE | ORA_CHAR_12 |
TEMPORARY_DBA | Oracle monitoring: data visible which is placed by this sess | ORA_TEMPORARY | ORA_CHAR_1 |
SECONDARY | Oracle monitoring: Is trigger a secondary object | ORA_SECONDARY | ORA_CHAR_1 |
NESTED | Oracle monitoring: Is the table a nested table? | ORA_NESTED | ORA_CHAR_3 |
BUFFER_POOL | Oracle monitoring: The default buffer pool for the object | ORA_BUFFER_POOL | ORA_CHAR_7 |
ROW_MOVEMENT | Oracle monitoring: partitioned row movement is enabled ? | ORA_ROW_MOVEMENT | ORA_CHAR_8 |
GLOBAL_STATS | Oracle monitoring: Stats collected for whole table or estima | ORA_GLOBAL_STATS | ORA_CHAR_3 |
USER_STATS | Oracle monitoring: Were statistics entered directly by user? | ORA_USER_STATS | ORA_CHAR_3 |
DURATION | Oracle monitoring: duration of a temporary table | ORA_DURATION | ORA_CHAR_15 |
SKIP_CORRUPT | Oracle monitoring: If Oracle ignores blocks marked corrupt | ORA_SKIP_CORRUPT | ORA_CHAR_8 |
MONITORING | Oracle monitoring: table has the MONITORING attribute set | ORA_MONITORING | ORA_CHAR_3 |
CLUSTER_OWNER | Oracle monitoring: Cluster owner | ORA_CLUSTER_OWNER | ORA_CHAR_30 |
DEPENDENCIES | Oracle monitoring: Dependencies | ORA_DEPENDENCIES | ORA_CHAR_8 |
COMPRESSION | Oracle monitoring: Compression | ORA_COMPRESSION | ORA_CHAR_8 |
ORA_DBA_TABLES related tables
Table | Note |
---|---|
ORA_DBA_TABLES | Copy of DBA_TABLES (currently not provided with snapshots) |
GVD_DATABASE | Copy of GV$DATABASE (currently not provided with snapshots) |
GVD_LATCHNAME | Copy of GV$LATCHNAME (currently not provided with snapshots) |
GVD_SESS_IO | Copy of GV$SESS_IO (currently not provided with snapshots) |
GVD_SQL | Copy of GV$SQL (currently not provided with snapshots) |
GVD_SQLAREA | Copy of GV$SQLAREA (currently not provided with snapshots) |
GVD_SQLTEXT | Copy of GV$SQLTEXT (currently not provided with snapshots) |
ORA_DBA_EXTENTS | Copy of DBA_EXTENTS (currently not provided with snapshots) |
ORA_DBA_OBJECTS | Copy of DBA_OBJECTS (currently not provided with snapshots) |
ORA_DBA_SEGMENTS | Copy of DBA_SEGMENTS (currently not provided with snapshots) |
GVD_DB_CACHE_ADV | Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps) |
GVD_LATCHHOLDER | Copy of GV$LATCHHOLDER (currently not provided with snapsh) |
GVD_LATCH_PARENT | Copy of GV$LATCH_PARENT (currently not provided with snaps) |
GVD_MANGD_STANBY | copy of GV$MANAGED_STANDBY (currently not provided w. snaps) |
GVD_PARAMETER2 | Copy of GV$PARAMETER2 (currently not provided with snapshot |
Stock provided to vendor TablesStock provided to vendor table TablesStock provided to vendor tcode TablesSap handling unit is not provided for goods receipt TablesSap handling unit is not provided for goods receipt TablesSap no cost management is provided for sales document item TablesCopy control Tables copy document Tables
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP