SAP ABAP Table GVD_DATAFILE (Copy of GV$DATAFILE)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷ STUN (Package) DBA: All the rest in English
⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷ STUN (Package) DBA: All the rest in English
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | GVD_DATAFILE | Table Relationship Diagram |
Short Description | Copy of GV$DATAFILE |
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 | SNAPSHOT_ID | ORA_SNAPSHOT_ID | ORA_SNAPSHOT_ID | NUMC | 10 | 0 | Oracle monitor: snapshot ID | * | |
2 | INST_ID | ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
3 | FILE_DATAFILE | ORA_FILE | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: File# | ||
4 | CREATION_CHANGE | ORA_CREATION_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: creation_change# | ||
5 | CREATION_TIME_D | ORA_CREATION_DATE | ORA_DATE | DATS | 8 | 0 | Oracle Monitoring: creation date | ||
6 | CREATION_TIME_T | ORA_CREATION_TIME | ORA_TIME | TIMS | 6 | 0 | Oracle Monitoring: creation time | ||
7 | TS | ORA_TS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: File tablespace number | ||
8 | RFILE | ORA_RFILE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: rfile# | ||
9 | STATUS | ORA_STATUS_DF | ORA_CHAR_7 | CHAR | 7 | 0 | Oracle monitoring: ora_status | ||
10 | ENABLED | ORA_ENABLED | ORA_CHAR_10 | CHAR | 10 | 0 | Oracle Monitoring: enabled | ||
11 | CHECKPOINT_CHANG | ORA_CHECKPOINT_CHANGE_DF | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: file checkpoint change number | ||
12 | CHECKPOINT_TIMED | ORA_CHECKPOINT_DATE | ORA_DATE | DATS | 8 | 0 | Oracle Monitoring: checkpoint_time | ||
13 | CHECKPOINT_TIMET | ORA_CHECKPOINT_TIME | ORA_TIME | TIMS | 6 | 0 | Oracle Monitoring: checkpoint_time | ||
14 | UNRECOVERABLE_CH | ORA_UNRECOVERABLE_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: unrecoverable_change# | ||
15 | UNRECOVERABLE_TD | ORA_UNRECOVERABLE_DATE | ORA_DATE | DATS | 8 | 0 | Oracle monitoring: unrecoverable_date | ||
16 | UNRECOVERABLE_TT | ORA_UNRECOVERABLE_TIME | ORA_TIME | TIMS | 6 | 0 | Oracle monitoring: unrecoverable_time | ||
17 | LAST_CHANGE | ORA_LAST_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: last_change# | ||
18 | LAST_TIME_D | ORA_LAST_DATE | ORA_DATE | DATS | 8 | 0 | Oracle monitoring: last_time (date value) | ||
19 | LAST_TIME_T | ORA_LAST_TIME | ORA_TIME | TIMS | 6 | 0 | Oracle monitoring: last_time | ||
20 | OFFLINE_CHANGE | ORA_OFFLINE_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: offline_change# | ||
21 | ONLINE_CHANGE | ORA_ONLINE_CHANGE | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: online_change# | ||
22 | ONLINE_TIME_D | ORA_ONLINE_DATE | ORA_DATE | DATS | 8 | 0 | Oracle monitoring: online_time (date value) | ||
23 | ONLINE_TIME_T | ORA_ONLINE_TIME | ORA_TIME | TIMS | 6 | 0 | Oracle monitoring: online_time | ||
24 | BYTES | ORA_BYTES_DF | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: bytes | ||
25 | BLOCKS | ORA_BLOCKS_DF | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: blocks | ||
26 | CREATE_BYTES | ORA_CREATE_BYTES | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitor: CREATE BYTES | ||
27 | BLOCK_SIZE | ORA_BLOCK_SIZE | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitor: BLOCK SIZE | ||
28 | NAME | ORA_NAME_DF | ORA_STRING_513 | STRG | 513 | 0 | Oracle monitoring: name | ||
29 | PLUGGED_IN | ORA_PLUGGED_IN | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: plugged_in | ||
30 | BLOCK1_OFFSET | ORA_BLOCK1_OFFSET | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: block1_offset | ||
31 | AUX_NAME | ORA_AUX_NAME | ORA_STRING_513 | STRG | 513 | 0 | Oracle monitoring: aux_name |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 700 |