ORA_DBA_SEGMENTS is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of ORA_DBA_SEGMENTS in SAP.
- Table description : Copy of DBA_SEGMENTS (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_SEGMENTS 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 |
| SEGMENT_NAME | Oracle monitoring: Segment name | ORA_SEGMENT_NAME | ORA_CHAR_81 |
| PARTITION_NAME | Oracle monitoring: Object Partition Name | ORA_PARTITION_NAME | ORA_CHAR_30 |
| SEGMENT_TYPE | Oracle monitoring: Segment type | ORA_SEGMENT_TYPE | ORA_SEGMENT_TYPE |
| TABLESPACE_NAME | Oracle monitoring: Tablespacename to which objects belong | ORA_TABLESPACE_NAME | ORA_CHAR_30 |
| HEADER_FILE | Oracle monitoring: ID of file containing the segment header | ORA_HEADER_FILE | ORA_NUM_22 |
| HEADER_BLOCK | Oracle monitoring:ID of block containing the segment header | ORA_HEADER_BLOCK | ORA_NUM_22 |
| BYTES | Oracle monitoring: Size of segment (Bytes) | ORA_BYTES_SEG | ORA_NUM_22 |
| BLOCKS | Oracle monitoring: Size of segment in Oracle blocks | ORA_BLOCKS_SEG | ORA_NUM_22 |
| EXTENTS | Oracle monitoring: Number of extents allocated to segment | ORA_EXTENTS | 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 |
| RELATIVE_FNO | Oracle monitoring: Relative file number of segment header | ORA_RELATIVE_FNO | ORA_NUM_22 |
| BUFFER_POOL | Oracle monitoring: The default buffer pool for the object | ORA_BUFFER_POOL | ORA_CHAR_7 |
ORA_DBA_SEGMENTS related tables
| Table | Note |
|---|---|
| ORA_DBA_SEGMENTS | Copy of DBA_SEGMENTS (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_TABLES | Copy of DBA_TABLES (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