SAP ABAP Table LATCH (Latch Monitoring)
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 | LATCH |
Table Relationship Diagram 
|
| Short Description | Latch Monitoring |
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 |  NAME |
ORA_NAME | ORA_CHAR_64 | CHAR | 64 | 0 | Oracle monitoring: Name | ||
| 2 | INST_ID |
ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
| 3 | GETS |
ORA_GETS | ORA_GETS | DEC | 22 | 0 | Oracle monitoring: Latch Gets | ||
| 4 | MISSES |
ORA_MISSES | ORA_MISSES | DEC | 22 | 0 | Oracle monitoring: Latch Misses | ||
| 5 | R_MISSES_GETS |
ORA_R_MISSES_GETS | DEC | 22 | 5 | Oracle Monitoring: GV$LATCH ratio misses / gets | |||
| 6 | SLEEPS |
ORA_SLEEPS | ORA_SLEEPS | DEC | 22 | 0 | Oracle monitoring: Latch Sleeps | ||
| 7 | PCT_SLEEPS |
ORA_PCT_SLEEPS | PERCENTAGE | DEC | 8 | 4 | Oracle Monitoring: GV$LATCH % of sleeps | ||
| 8 | IMMEDIATE_GETS |
ORA_IMMEDIATE_GETS | ORA_IMMEDIATE_GETS | DEC | 22 | 0 | Oracle monitoring: Latch Immediate Gets | ||
| 9 | IMMEDIATE_MISSES |
ORA_IMMEDIATE_MISSES | ORA_IMMEDIATE_MISSES | DEC | 22 | 0 | Oracle monitoring: Latch Immediate Misses | ||
| 10 | SPIN_GETS |
ORA_SPIN_GETS | ORA_SPIN_GETS | DEC | 22 | 0 | Oracle monitoring: Latch Spin Gets | ||
| 11 | SLEEP1 |
ORA_SLEEP1 | ORA_SLEEP1 | DEC | 22 | 0 | Oracle monitoring: Latch Sleep 1 | ||
| 12 | SLEEP2 |
ORA_SLEEP2 | ORA_SLEEP2 | DEC | 22 | 0 | Oracle monitoring: Latch Sleep 2 | ||
| 13 | SLEEP3 |
ORA_SLEEP3 | ORA_SLEEP3 | DEC | 22 | 0 | Oracle monitoring: Latch Sleep 3 | ||
| 14 | SLEEP4 |
ORA_SLEEP4 | ORA_SLEEP4 | DEC | 22 | 0 | Oracle monitoring: Latch Sleep 4 | ||
| 15 | WAIT_TIME |
ORA_LATCH_WAIT_TIME | ORA_WAIT_TIME | DEC | 22 | 0 | Oracle monitoring: Latch Wait Time | ||
| 16 | PCT_WAIT_TIME |
ORA_PCT_WAIT_TIME | PERCENTAGE | DEC | 8 | 4 | Oracle Monitoring: GV$LATCH % wait time |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 700 |
