SAP ABAP Table ORA_S_FILE_INFO (Oracle file statistics, mainly from gv$filestat (ASHmonitor))
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
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 | INTTAB | Structure |
| Structure | ORA_S_FILE_INFO |
Table Relationship Diagram 
|
| Short Description | Oracle file statistics, mainly from gv$filestat (ASHmonitor) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  SESSION_CNT |
ORA_SESSION_CNT | ORA_DEC_10 | DEC | 10 | 0 | Oracle Monitoring: Oracle Session Count | ||
| 2 | DF_NAME |
ORA_NAME_DF | ORA_STRING_513 | STRG | 513 | 0 | Oracle monitoring: name | ||
| 3 | INST_ID |
ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
| 4 | FILE_HASH |
ORA_FILE | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: File# | ||
| 5 | PHYRDS |
ORA_PHYRDS | ORA_NUMBER | DEC | 22 | 0 | Oracel monitoring: filestat physical reads | ||
| 6 | PHYWRTS |
ORA_PHYWRTS | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat physical writes | ||
| 7 | PHYBLKRD |
ORA_PHYBLKRD | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat physical block read | ||
| 8 | PHYBLKWRT |
ORA_PHYBLKWRT | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat physical block writes | ||
| 9 | SINGLEBLKRDS |
ORA_SINGLEBLKRDS | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat single block reads | ||
| 10 | READTIM |
ORA_READTIM | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat read time | ||
| 11 | WRITETIM |
ORA_WRITETIM | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat write time | ||
| 12 | SINGLEBLKRDTIM |
ORA_SINGLEBLKRDTIM | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat single block read time | ||
| 13 | AVGIOTIM |
ORA_AVGIOTIM | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat average I/O time | ||
| 14 | LSTIOTIM |
ORA_LSTIOTIM | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat lst I/O time | ||
| 15 | MINIOTIM |
ORA_MINIOTIM | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat min I/O time | ||
| 16 | MAXIORTM |
ORA_MAXIORTM | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat max I/O read time | ||
| 17 | MAXIOWTM |
ORA_MAXIOWTM | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: filestat max I/O wait time |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 710 |
