Table/Structure Field list used by SAP ABAP Function Module MONITOR_SM_ORASESSION (Oracle Session Monitor Data Collector)
SAP ABAP Function Module 
MONITOR_SM_ORASESSION (Oracle Session Monitor Data Collector) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
MSXXLIST - HOST | Name of the Host Server | |
| 2 | Table/Structure Field |
MSXXLIST - HOSTADR | Host IP address | |
| 3 | Table/Structure Field |
MSXXLIST - MSGTYPES | Services of the Application Server Instance | |
| 4 | Table/Structure Field |
MSXXLIST - NAME | Application Server Instance | |
| 5 | Table/Structure Field |
MSXXLIST - SERV | Service | |
| 6 | Table/Structure Field |
MSXXLIST - SERVNO | Service port number | |
| 7 | Table/Structure Field |
MSXXLIST - STATE | Server Status | |
| 8 | Table/Structure Field |
ORA_PROCESSROW - BLOCK_CHG | Oracle monitoring: BLOCK_CHANGES: Block changes for session | |
| 9 | Table/Structure Field |
ORA_PROCESSROW - BLOCK_GETS | Oracle monitoring: ORA_BLOCK_GETS: Block gets for this sessi | |
| 10 | Table/Structure Field |
ORA_PROCESSROW - COMMAND | Oracle monitoring: COMMAND: Command in progress | |
| 11 | Table/Structure Field |
ORA_PROCESSROW - CONSIST_GETS | Oracle monitoring: CONSISTENT_GETS: Consistent gets for sess | |
| 12 | Table/Structure Field |
ORA_PROCESSROW - EVENT | Oracle monitor: EVENT | |
| 13 | Table/Structure Field |
ORA_PROCESSROW - INSTANCE_NAME | Oracle monitoring: instance_name | |
| 14 | Table/Structure Field |
ORA_PROCESSROW - INSTANCE_NUMBER | Oracle monitoring: instance number | |
| 15 | Table/Structure Field |
ORA_PROCESSROW - LOGICAL_READS | Oracle Monitoring: Logical Reads | |
| 16 | Table/Structure Field |
ORA_PROCESSROW - MACHINE | Oracle monitoring: MACHINE: Operating system machine name | |
| 17 | Table/Structure Field |
ORA_PROCESSROW - PADDR | Oracle monitoring: PADDR: Address of proc. owning the sess. | |
| 18 | Table/Structure Field |
ORA_PROCESSROW - PGA_ALLOC_MEM | Oracle monitoring: PGA memory allocated by the process | |
| 19 | Table/Structure Field |
ORA_PROCESSROW - PGA_FREEABLE_MEM | Oracle monitoring: Allocated PGA memory which can be freed | |
| 20 | Table/Structure Field |
ORA_PROCESSROW - PGA_MAX_MEM | Oracle monitoring: Max PGA memory allocated by the process | |
| 21 | Table/Structure Field |
ORA_PROCESSROW - PGA_USED_MEM | Oracle monitoring: PGA memory currently used by the process | |
| 22 | Table/Structure Field |
ORA_PROCESSROW - PHYS_READS | Oracle monitoring: PHYSICAL_READS: Physical reads for sess. | |
| 23 | Table/Structure Field |
ORA_PROCESSROW - PROCESS | Oracle monitoring: OS Process Id | |
| 24 | Table/Structure Field |
ORA_PROCESSROW - PROCPROG | Oracle monitoring: PROGRAM: Operating system program name | |
| 25 | Table/Structure Field |
ORA_PROCESSROW - SECONDS_IN_WAIT | Oracle monitoring: SECONDS_IN_WAIT: | |
| 26 | Table/Structure Field |
ORA_PROCESSROW - SESSPROG | Oracle monitoring: PROGRAM: Operating system program name | |
| 27 | Table/Structure Field |
ORA_PROCESSROW - SID | Oracle monitoring: SID (Session) | |
| 28 | Table/Structure Field |
ORA_PROCESSROW - SPID | Oracle monitoring: Operating system process identifier | |
| 29 | Table/Structure Field |
ORA_PROCESSROW - SQLTEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | |
| 30 | Table/Structure Field |
ORA_PROCESSROW - SQL_ADDRESS | Oracle monitoring: SQL_ADDRESS: SQL Statement ID | |
| 31 | Table/Structure Field |
ORA_PROCESSROW - SQL_HASH_VALUE | Oracle monitoring: SQL_HASH_VALUE: SQL statement hash | |
| 32 | Table/Structure Field |
ORA_PROCESSROW - STATUS | Oracle monitoring: Current process status | |
| 33 | Table/Structure Field |
ORA_PROCESSROW - TYPE | Oracle Monitoring: Type of user or system lock | |
| 34 | Table/Structure Field |
ORA_PROCESSROW - USERNAME | Oracle monitoring: USERNAME: Oracle username | |
| 35 | Table/Structure Field |
ORA_PROCESSROW - WAIT_P1 | Oracle monitoring: ORA_P1: First additional parameter | |
| 36 | Table/Structure Field |
ORA_PROCESSROW - WAIT_P1TEXT | Oracle monitoring: ORA_P1TEXT: Description of 1. param. | |
| 37 | Table/Structure Field |
ORA_PROCESSROW - WAIT_P2 | Oracle monitoring: ORA_P2: Second additional parameter | |
| 38 | Table/Structure Field |
ORA_PROCESSROW - WAIT_P2TEXT | Oracle monitoring: ORA_P1TEXT: Description of 2. param. | |
| 39 | Table/Structure Field |
ORA_PROCESSROW - WAIT_P3 | Oracle monitoring: ORA_P3: Third additional parameter | |
| 40 | Table/Structure Field |
ORA_PROCESSROW - WAIT_P3TEXT | Oracle monitoring: ORA_P1TEXT: Description of 3. param. | |
| 41 | Table/Structure Field |
ORA_SERVERLISTROW - HOST | Oracle Monitoring: ORA_MSHOST2 | |
| 42 | Table/Structure Field |
ORA_SERVERLISTROW - HOSTADR | Oracle Monitoring: ORA_MSHOSTADR | |
| 43 | Table/Structure Field |
ORA_SERVERLISTROW - MSGTYPES | Oracle Monitoring: ORA_MSTYPES | |
| 44 | Table/Structure Field |
ORA_SERVERLISTROW - NAME | Oracle Monitoring: ORA_MSNAME2 | |
| 45 | Table/Structure Field |
ORA_SERVERLISTROW - SERV | Oracle Monitoring: ORA_MSSERV | |
| 46 | Table/Structure Field |
ORA_SERVERLISTROW - SERVNO | Oracle Monitoring: MSSERVNO | |
| 47 | Table/Structure Field |
ORA_SERVERLISTROW - STATE | Oracle Monitoring: ORA_MSSTATE | |
| 48 | Table/Structure Field |
ORA_SNAPSHOT - ORA_SYSDATE_D | Oracle system date of snapshot | |
| 49 | Table/Structure Field |
ORA_SNAPSHOT - ORA_SYSDATE_T | Oracle system time of snapshot | |
| 50 | Table/Structure Field |
ORA_SNAPSHOT - SNAPSHOT_ID | Oracle monitor: snapshot ID | |
| 51 | Table/Structure Field |
ORA_SQLTEXTROW - ADDRESS | Oracle monitoring: ADDRESS: Address of a cursor | |
| 52 | Table/Structure Field |
ORA_SQLTEXTROW - HASH_VALUE | Oracle monitoring: HASH_VALUE: Cursor hash | |
| 53 | Table/Structure Field |
ORA_SQLTEXTROW - INST_ID | Oracle monitor: Instance ID | |
| 54 | Table/Structure Field |
ORA_SQLTEXTROW - SQL_TEXT | Oracle monitoring: SQL_TEXT: A column containing 1 SQL Text | |
| 55 | Table/Structure Field |
ORA_WPTOTALINFROW - BTCJOBCNT | Oracle Monitoring:_BTCJOBCNT:Job ID | |
| 56 | Table/Structure Field |
ORA_WPTOTALINFROW - BTCJOBNAME | Oracle Monitoring:BTCJOB: Background job name | |
| 57 | Table/Structure Field |
ORA_WPTOTALINFROW - CUAPROGRAM | Oracle Monitoring: CUA program name | |
| 58 | Table/Structure Field |
ORA_WPTOTALINFROW - DYNPRONR | Oracle Monitoring: Screen number or transaction name | |
| 59 | Table/Structure Field |
ORA_WPTOTALINFROW - FCODE | Oracle Monitoring: WPTOTINFFC:Function code | |
| 60 | Table/Structure Field |
ORA_WPTOTALINFROW - MEMSUM | Oracle Monitoring: MEMSUM: Extended memory | |
| 61 | Table/Structure Field |
ORA_WPTOTALINFROW - PRIVSUM | Oracle Monitoring:Heap (private) Memory | |
| 62 | Table/Structure Field |
ORA_WPTOTALINFROW - STARTDATE | Oracle Monitoring: Start date for dialog step | |
| 63 | Table/Structure Field |
ORA_WPTOTALINFROW - STARTTIME | Oracle Monitoring: Start time for dialog step | |
| 64 | Table/Structure Field |
ORA_WPTOTALINFROW - TCODE | Oracle Monitoring: Transaction code | |
| 65 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_ACTION | Oracle Monitoring: WPACTION: Currently activity of WP | |
| 66 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_BNAME | Oracle Monitoring: WPBNAME: User currently served | |
| 67 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_CPU | Oracle Monitoring: WPCPU: CPU | |
| 68 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_DUMPS | Oracle Monitoring: WPDUMPS: Number of dumps. | |
| 69 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_ELTIME | Oracle Monitoring: WPELZEIT: Previous execution time of requ | |
| 70 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_IACTION | Oracle Monitoring: WPIACTION: Current activity of the work p | |
| 71 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_INDEX | Oracle Monitoring: ORA_WPINDEX: Index of work process | |
| 72 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_IRESTRT | Oracle Monitoring: WPIRESTART : Restart after error? | |
| 73 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_ISTATUS | Oracle Monitoring: WPISTATUS: Work process status | |
| 74 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_ITYPE | Oracle Monitoring: WPITYPE : Internal work process type | |
| 75 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_IWAIT | Oracle Monitorign: WPIWAITING: Reason for wait | |
| 76 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_MANDT | Client | |
| 77 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_NO | Oracle Monitoring: WPNO: Work process number | |
| 78 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_PID | Oracle Monitoring : WPPID: Work process PID | |
| 79 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_REPORT | Oracle Monitoring: WPREPORT: Report currently being executed | |
| 80 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_RESTART | Oracle Monitoring: WPRESTART: Restart work process after dum | |
| 81 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_SEM | Oracle Monitoring: WPSEM: Semaphore, for which the work proc | |
| 82 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_SEMSTAT | Oracle Monitoring: WPITYPE : Internal work process type | |
| 83 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_SERVER | Oracle Monitoring: MSNAME: Servername | |
| 84 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_STATUS | Oracle Monitoring: WPSTATUS: Work process status | |
| 85 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_TABLE | Oracle Monitoring: WPTABLE: DB table last accessed by the WP | |
| 86 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_TYP | Oracle Monitoring: WPTYP: Type | |
| 87 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_WAITINF | Oracle Monitoring: WPWAITINF: add. wait information | |
| 88 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_WAITING | Oracle Monitoring: WPWAITING: Work process is waiting | |
| 89 | Table/Structure Field |
ORA_WPTOTALINFROW - WP_WAITTIM | Oracle Monitoring: WPWAITTIME: Time when waiting started | |
| 90 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 91 | Table/Structure Field |
SYST - FDPOS | ABAP System Field: Occurrence in Byte or Character String | |
| 92 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server | |
| 93 | Table/Structure Field |
WPINFO - WP_ACTION | Current Activity of the Work Process | |
| 94 | Table/Structure Field |
WPINFO - WP_BNAME | User Currently Served | |
| 95 | Table/Structure Field |
WPINFO - WP_CPU | CPU | |
| 96 | Table/Structure Field |
WPINFO - WP_DUMPS | Number of Dumps of the Work Process | |
| 97 | Table/Structure Field |
WPINFO - WP_ELTIME | Previous Runtime of Request (elapsed) | |
| 98 | Table/Structure Field |
WPINFO - WP_IACTION | Current activity of the work process | |
| 99 | Table/Structure Field |
WPINFO - WP_INDEX | Work Process Number | |
| 100 | Table/Structure Field |
WPINFO - WP_IRESTRT | Restart After Error | |
| 101 | Table/Structure Field |
WPINFO - WP_ISTATUS | Work process status | |
| 102 | Table/Structure Field |
WPINFO - WP_ITYPE | Internal work process type | |
| 103 | Table/Structure Field |
WPINFO - WP_IWAIT | Reason for wait | |
| 104 | Table/Structure Field |
WPINFO - WP_MANDT | Client | |
| 105 | Table/Structure Field |
WPINFO - WP_NO | (Deprecated) Use WP_UNDEX | |
| 106 | Table/Structure Field |
WPINFO - WP_PID | Process Identification | |
| 107 | Table/Structure Field |
WPINFO - WP_REPORT | Report now running | |
| 108 | Table/Structure Field |
WPINFO - WP_RESTART | Restart work process after dump? | |
| 109 | Table/Structure Field |
WPINFO - WP_SEM | Semaphore that the work process is waiting for | |
| 110 | Table/Structure Field |
WPINFO - WP_SEMSTAT | Internal work process type | |
| 111 | Table/Structure Field |
WPINFO - WP_SERVER | Server Name | |
| 112 | Table/Structure Field |
WPINFO - WP_STATUS | Work process status | |
| 113 | Table/Structure Field |
WPINFO - WP_TABLE | DB table last accessed by the work process | |
| 114 | Table/Structure Field |
WPINFO - WP_TYP | Type | |
| 115 | Table/Structure Field |
WPINFO - WP_WAITINF | Additional information about the reason for waiting | |
| 116 | Table/Structure Field |
WPINFO - WP_WAITING | Why Work Process is Waiting | |
| 117 | Table/Structure Field |
WPINFO - WP_WAITTIM | Time when waiting started | |
| 118 | Table/Structure Field |
WPTOTLINFO - BTCJOBCNT | Job ID | |
| 119 | Table/Structure Field |
WPTOTLINFO - BTCJOBNAME | Background job name | |
| 120 | Table/Structure Field |
WPTOTLINFO - CUAPROGRAM | CUA program name | |
| 121 | Table/Structure Field |
WPTOTLINFO - DYNPRONR | Screen number or transaction name | |
| 122 | Table/Structure Field |
WPTOTLINFO - FCODE | Function code | |
| 123 | Table/Structure Field |
WPTOTLINFO - MEMSUM | Extended memory | |
| 124 | Table/Structure Field |
WPTOTLINFO - PRIVSUM | Heap (private) Memory | |
| 125 | Table/Structure Field |
WPTOTLINFO - STARTDATE | Start date for dialog step | |
| 126 | Table/Structure Field |
WPTOTLINFO - STARTTIME | Start time for dialog step | |
| 127 | Table/Structure Field |
WPTOTLINFO - TCODE | Transaction code | |
| 128 | Table/Structure Field |
WPTOTLINFO - WP_ACTION | Current Activity of the Work Process | |
| 129 | Table/Structure Field |
WPTOTLINFO - WP_BNAME | User Currently Served | |
| 130 | Table/Structure Field |
WPTOTLINFO - WP_CPU | CPU | |
| 131 | Table/Structure Field |
WPTOTLINFO - WP_DUMPS | Number of Dumps of the Work Process | |
| 132 | Table/Structure Field |
WPTOTLINFO - WP_ELTIME | Previous Runtime of Request (elapsed) | |
| 133 | Table/Structure Field |
WPTOTLINFO - WP_IACTION | Current activity of the work process | |
| 134 | Table/Structure Field |
WPTOTLINFO - WP_INDEX | Work Process Number | |
| 135 | Table/Structure Field |
WPTOTLINFO - WP_IRESTRT | Restart After Error | |
| 136 | Table/Structure Field |
WPTOTLINFO - WP_ISTATUS | Work process status | |
| 137 | Table/Structure Field |
WPTOTLINFO - WP_ITYPE | Internal work process type | |
| 138 | Table/Structure Field |
WPTOTLINFO - WP_IWAIT | Reason for wait | |
| 139 | Table/Structure Field |
WPTOTLINFO - WP_MANDT | Client | |
| 140 | Table/Structure Field |
WPTOTLINFO - WP_NO | (Deprecated) Use WP_UNDEX | |
| 141 | Table/Structure Field |
WPTOTLINFO - WP_PID | Process Identification | |
| 142 | Table/Structure Field |
WPTOTLINFO - WP_REPORT | Report now running | |
| 143 | Table/Structure Field |
WPTOTLINFO - WP_RESTART | Restart work process after dump? | |
| 144 | Table/Structure Field |
WPTOTLINFO - WP_SEM | Semaphore that the work process is waiting for | |
| 145 | Table/Structure Field |
WPTOTLINFO - WP_SEMSTAT | Internal work process type | |
| 146 | Table/Structure Field |
WPTOTLINFO - WP_SERVER | Server Name | |
| 147 | Table/Structure Field |
WPTOTLINFO - WP_STATUS | Work process status | |
| 148 | Table/Structure Field |
WPTOTLINFO - WP_TABLE | DB table last accessed by the work process | |
| 149 | Table/Structure Field |
WPTOTLINFO - WP_TYP | Type | |
| 150 | Table/Structure Field |
WPTOTLINFO - WP_WAITINF | Additional information about the reason for waiting | |
| 151 | Table/Structure Field |
WPTOTLINFO - WP_WAITING | Why Work Process is Waiting | |
| 152 | Table/Structure Field |
WPTOTLINFO - WP_WAITTIM | Time when waiting started |
