SAP ABAP Table ORA_PROCESSROW (Oracle Monitoring: Processes-row type)
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_PROCESSROW |
Table Relationship Diagram 
|
| Short Description | Oracle Monitoring: Processes-row type |
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_SID | ORA_SID | DEC | 22 | 0 | Oracle monitoring: SID (Session) | ||
| 2 | INSTANCE_NUMBER |
ORA_INSTANCE_NUMBER | ORA_NUMBER | DEC | 22 | 0 | Oracle monitoring: instance number | ||
| 3 | INSTANCE_NAME |
ORA_INSTANCE_NAME | ORA_LK_INSTNAME | CHAR | 48 | 0 | Oracle monitoring: instance_name | ||
| 4 | PADDR |
ORA_PADDR | ORA_PADDR | RAW | 8 | 0 | Oracle monitoring: PADDR: Address of proc. owning the sess. | ||
| 5 | USERNAME |
ORA_USERNAME | ORA_USERNAME | CHAR | 30 | 0 | Oracle monitoring: USERNAME: Oracle username | ||
| 6 | SQL_ADDRESS |
ORA_SQL_ADDRESS | ORA_SQL_ADDRESS | RAW | 8 | 0 | Oracle monitoring: SQL_ADDRESS: SQL Statement ID | ||
| 7 | SQL_HASH_VALUE |
ORA_SQL_HASH_VALUE | ORA_SQL_HASH_VALUE | DEC | 22 | 0 | Oracle monitoring: SQL_HASH_VALUE: SQL statement hash | ||
| 8 | SPID |
ORA_SPID | ORA_CHAR_12 | CHAR | 12 | 0 | Oracle monitoring: Operating system process identifier | ||
| 9 | PROCPROG |
ORA_PROGRAM | ORA_PROGRAM | CHAR | 48 | 0 | Oracle monitoring: PROGRAM: Operating system program name | ||
| 10 | PROCESS |
ORA_PROCESS | ORA_PROCESS | CHAR | 12 | 0 | Oracle monitoring: OS Process Id | ||
| 11 | MACHINE |
ORA_MACHINE | ORA_MACHINE | CHAR | 64 | 0 | Oracle monitoring: MACHINE: Operating system machine name | ||
| 12 | SESSPROG |
ORA_PROGRAM | ORA_PROGRAM | CHAR | 48 | 0 | Oracle monitoring: PROGRAM: Operating system program name | ||
| 13 | COMMAND |
ORA_COMMAND | ORA_COMMAND | DEC | 22 | 0 | Oracle monitoring: COMMAND: Command in progress | ||
| 14 | STATUS |
ORA_STATUS | ORA_CHAR_12 | CHAR | 12 | 0 | Oracle monitoring: Current process status | ||
| 15 | TYPE |
ORA_TYPE | ORA_TYPE | CHAR | 2 | 0 | Oracle Monitoring: Type of user or system lock | ||
| 16 | EVENT |
ORA_EVENT | ORA_CHAR_64 | CHAR | 64 | 0 | Oracle monitor: EVENT | ||
| 17 | BLOCK_GETS |
ORA_BLOCK_GETS | ORA_BLOCK_GETS | DEC | 22 | 0 | Oracle monitoring: ORA_BLOCK_GETS: Block gets for this sessi | ||
| 18 | CONSIST_GETS |
ORA_CONSISTENT_GETS | ORA_CONSISTENT_GETS | DEC | 22 | 0 | Oracle monitoring: CONSISTENT_GETS: Consistent gets for sess | ||
| 19 | PHYS_READS |
ORA_PHYSICAL_READS | ORA_PHYSICAL_READS | DEC | 22 | 0 | Oracle monitoring: PHYSICAL_READS: Physical reads for sess. | ||
| 20 | BLOCK_CHG |
ORA_BLOCK_CHANGES | ORA_BLOCK_CHANGES | DEC | 22 | 0 | Oracle monitoring: BLOCK_CHANGES: Block changes for session | ||
| 21 | LOGICAL_READS |
ORA_LOGICAL_READS | ORA_BLOCK_CHANGES | DEC | 22 | 0 | Oracle Monitoring: Logical Reads | ||
| 22 | SECONDS_IN_WAIT |
ORA_SECONDS_IN_WAIT | ORA_SECONDS_IN_WAIT | DEC | 22 | 0 | Oracle monitoring: SECONDS_IN_WAIT: | ||
| 23 | WAIT_P1TEXT |
ORA_P1TEXT | ORA_P1TEXT | CHAR | 64 | 0 | Oracle monitoring: ORA_P1TEXT: Description of 1. param. | ||
| 24 | WAIT_P1 |
ORA_P1 | ORA_P1 | DEC | 22 | 0 | Oracle monitoring: ORA_P1: First additional parameter | ||
| 25 | WAIT_P2TEXT |
ORA_P2TEXT | ORA_P2TEXT | CHAR | 64 | 0 | Oracle monitoring: ORA_P1TEXT: Description of 2. param. | ||
| 26 | WAIT_P2 |
ORA_P2 | ORA_P2 | DEC | 22 | 0 | Oracle monitoring: ORA_P2: Second additional parameter | ||
| 27 | WAIT_P3TEXT |
ORA_P3TEXT | ORA_P3TEXT | CHAR | 64 | 0 | Oracle monitoring: ORA_P1TEXT: Description of 3. param. | ||
| 28 | WAIT_P3 |
ORA_P3 | ORA_P3 | DEC | 22 | 0 | Oracle monitoring: ORA_P3: Third additional parameter | ||
| 29 | SQLTEXT |
ORA_SQL_TEXT | ORA_CHAR_1000 | LCHR | 1000 | 0 | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ||
| 30 | PGA_USED_MEM |
ORA_PGA_USED_MEM | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: PGA memory currently used by the process | ||
| 31 | PGA_ALLOC_MEM |
ORA_PGA_ALLOC_MEM | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: PGA memory allocated by the process | ||
| 32 | PGA_FREEABLE_MEM |
ORA_PGA_FREEABLE_MEM | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Allocated PGA memory which can be freed | ||
| 33 | PGA_MAX_MEM |
ORA_PGA_MAX_MEM | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Max PGA memory allocated by the process |
History
| Last changed by/on | SAP | 20140117 |
| SAP Release Created in | 700 |
