SAP ABAP Table ORA_SM_SESSIONS (SDD - Oracle session monitor: session list)
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_SM_SESSIONS |
Table Relationship Diagram 
|
| Short Description | SDD - Oracle session monitor: session list |
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 |  SID |
ORA_LK_SID | ORA_LK_SID | NUMC | 22 | 0 | SDD - Oracle lock monitor: SID | ||
| 2 | INSTANCE_NUMBER |
ORA_LK_INSTID | ORA_LK_INSTID | DEC | 22 | 0 | SDD - Oracle lock monitor: Instance ID | ||
| 3 | INSTANCE_NAME |
ORA_LK_INSTNAME | ORA_LK_INSTNAME | CHAR | 48 | 0 | SDD - Oracle lock monitor: INSTNAME | ||
| 4 | PADDR |
ORA_LK_PADDR | ORA_LK_PADDR | RAW | 8 | 0 | SDD - Oracle lock monitor: PADDR | ||
| 5 | USERNAME |
ORA_SM_USERNAME | ORA_SM_USERNAME | CHAR | 30 | 0 | SDD - Oracle lock monitor: USERNAME | ||
| 6 | SQL_ADDRESS |
ORA_LK_SQLADDR | ORA_LK_SQLADDR | RAW | 8 | 0 | SDD - Oracle lock monitor: SQLADDR | ||
| 7 | SQL_HASH_VALUE |
ORA_LK_SQLHASH | ORA_LK_SQLHASH | NUMC | 22 | 0 | SDD - Oracle lock monitor: SQLHASH | ||
| 8 | SPID |
ORA_LK_SPID | ORA_LK_SPID | CHAR | 12 | 0 | SDD - Oracle lock monitor: SPID | ||
| 9 | PROCPROG |
ORA_SM_PROCPROG | ORA_SM_PROCPROG | CHAR | 48 | 0 | SDD - Oracle lock monitor: PROCPROG | ||
| 10 | PROCESS |
ORA_SM_PROCESS | ORA_SM_PROCESS | CHAR | 12 | 0 | SDD - Oracle lock monitor: PROCESS | ||
| 11 | MACHINE |
ORA_SM_MACHINE | ORA_SM_MACHINE | CHAR | 64 | 0 | SDD - Oracle lock monitor: MACHINE | ||
| 12 | SESSPROG |
ORA_SM_SESSPROG | ORA_SM_SESSPROG | CHAR | 48 | 0 | SDD - Oracle lock monitor: SESSPROG | ||
| 13 | COMMAND |
ORA_SM_COMMAND | ORA_SM_COMMAND | NUMC | 22 | 0 | SDD - Oracle lock monitor: COMMAND | ||
| 14 | STATUS |
ORA_SM_STATUS | ORA_SM_STATUS | CHAR | 12 | 0 | SDD - Oracle lock monitor: STATUS | ||
| 15 | TYPE |
ORA_SM_TYPE | ORA_SM_TYPE | CHAR | 2 | 0 | SDD - Oracle lock monitor: TYPE | ||
| 16 | EVENT |
ORA_SM_EVENT | ORA_SM_EVENT | CHAR | 64 | 0 | SDD - Oracle lock monitor: EVENT | ||
| 17 | BLOCK_GETS |
ORA_SM_BLGETS | ORA_SM_BLGETS | NUMC | 22 | 0 | SDD - Oracle lock monitor: BLGETS | ||
| 18 | CONSIST_GETS |
ORA_SM_COGETS | ORA_SM_COGETS | NUMC | 22 | 0 | SDD - Oracle lock monitor: COGETS | ||
| 19 | PHYS_READS |
ORA_SM_PHYREADS | ORA_SM_PHYREADS | NUMC | 22 | 0 | SDD - Oracle lock monitor: PHYREADS | ||
| 20 | BLOCK_CHG |
ORA_SM_BLKCHG | ORA_SM_BLKCHG | NUMC | 22 | 0 | SDD - Oracle lock monitor: BLKCHG | ||
| 21 | LOGICAL_READS |
ORA_SM_LOGREAD | ORA_SM_LOGREAD | NUMC | 22 | 0 | SDD - Oracle lock monitor: LOGREAD | ||
| 22 | SECONDS_IN_WAIT |
ORA_SM_SECIWAIT | ORA_SM_SECIWAIT | NUMC | 22 | 0 | SDD - Oracle lock monitor: SECIWAIT | ||
| 23 | WAIT_P1TEXT |
ORA_SM_WAITPT | ORA_SM_WAITPT | CHAR | 64 | 0 | SDD - Oracle lock monitor: WAITPT | ||
| 24 | WAIT_P1 |
ORA_SM_WAITP | ORA_SM_WAITP | NUMC | 22 | 0 | SDD - Oracle lock monitor: WAITP | ||
| 25 | WAIT_P2TEXT |
ORA_SM_WAITPT | ORA_SM_WAITPT | CHAR | 64 | 0 | SDD - Oracle lock monitor: WAITPT | ||
| 26 | WAIT_P2 |
ORA_SM_WAITP | ORA_SM_WAITP | NUMC | 22 | 0 | SDD - Oracle lock monitor: WAITP | ||
| 27 | WAIT_P3TEXT |
ORA_SM_WAITPT | ORA_SM_WAITPT | CHAR | 64 | 0 | SDD - Oracle lock monitor: WAITPT | ||
| 28 | WAIT_P3 |
ORA_SM_WAITP | ORA_SM_WAITP | NUMC | 22 | 0 | SDD - Oracle lock monitor: WAITP | ||
| 29 | SQLTEXT |
ORA_SM_SQLTEXT | ORA_SM_SQLTEXT | CHAR | 1000 | 0 | SDD - Oracle lock monitor: SQLTEXT | ||
| 30 | PGA_USED_MEM |
ORA_SM_USEDMEM | ORA_SM_USEDMEM | DEC | 22 | 0 | SDD - Oracle lock monitor: USEDMEM | ||
| 31 | PGA_ALLOC_MEM |
ORA_SM_ALLOMEM | ORA_SM_ALLOMEM | DEC | 22 | 0 | SDD - Oracle lock monitor: ALLOMEM | ||
| 32 | PGA_FREEABLE_MEM |
ORA_SM_FREEMEM | ORA_SM_FREEMEM | DEC | 22 | 0 | SDD - Oracle lock monitor: FREEMEM | ||
| 33 | PGA_MAX_MEM |
ORA_SM_MAXMEM | ORA_SM_MAXMEM | DEC | 22 | 0 | SDD - Oracle lock monitor: MAXMEM |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 700 |
