Table/Structure Field list used by SAP ABAP Function Module C_MONITOR_PG_SDD (Oracle database monitor "PGA": SDD (Service data download))
SAP ABAP Function Module
C_MONITOR_PG_SDD (Oracle database monitor "PGA": SDD (Service data download)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | GPG_TR_PEROPT - INSTANCE_NAME | Oracle monitoring: instance_name | ||
| 2 | GPG_TR_PEROPT - INST_ID | Oracle monitor: Instance ID | ||
| 3 | GPG_TR_PEROPT - MP_EXECUTIONS | Oracle Monitoring: MULTIPASSES_EXECUTIONS | ||
| 4 | GPG_TR_PEROPT - MP_PERC | GPG_TR_PEROPT-MP_PERC | ||
| 5 | GPG_TR_PEROPT - ONEPASS_EXECUTIO | Oracle Monitoring: ONEPASS_EXECUTIONS | ||
| 6 | GPG_TR_PEROPT - ONEPASS_PERC | GPG_TR_PEROPT-ONEPASS_PERC | ||
| 7 | GPG_TR_PEROPT - OPTIMAL_EXECUTIO | Oracle Monitoring: OPTIMAL_EXECUTIONS | ||
| 8 | GPG_TR_PEROPT - OPTIMAL_PERC | GPG_TR_PEROPT-OPTIMAL_PERC | ||
| 9 | GPG_TR_PEROPT - TOTAL_EXECUTIONS | Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass | ||
| 10 | GPG_TR_PGAADV - ESTD_OVERALLOC_C | Oracle monitoring: Estimated value of overalloc. count | ||
| 11 | GPG_TR_PGAADV - ESTD_PGA_CACHE_H | Oracle monitoring: Estimated value of the cache hit percent | ||
| 12 | GPG_TR_PGAADV - INSTANCE_NAME | Oracle monitoring: instance_name | ||
| 13 | GPG_TR_PGAADV - INST_ID | Oracle monitor: Instance ID | ||
| 14 | GPG_TR_PGAADV - PGA_TARGET_FOR_E | Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes) | ||
| 15 | GPG_TR_PGAHIS - ESTD_MPS_CNT | Oracle monitoring: Number of work areas - Multi Pass | ||
| 16 | GPG_TR_PGAHIS - ESTD_ONE_CNT | Oracle monitoring: Number of work areas - One Pass | ||
| 17 | GPG_TR_PGAHIS - ESTD_OPT_CNT | Oracle monitoring: Number of work areas - Optimal | ||
| 18 | GPG_TR_PGAHIS - HIGH_KB | Oracle monitoring: Higher bound for the memory requirement | ||
| 19 | GPG_TR_PGAHIS - INSTANCE_NAME | Oracle monitoring: instance_name | ||
| 20 | GPG_TR_PGAHIS - INST_ID | Oracle monitor: Instance ID | ||
| 21 | GPG_TR_PGAHIS - LOW_KB | Oracle monitoring: Lower bound for the memory requirement | ||
| 22 | GPG_TR_PGAHIS - PGA_TARGET_FACTO | Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR% | ||
| 23 | GPG_TR_PROCES - ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ||
| 24 | GPG_TR_PROCES - HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ||
| 25 | GPG_TR_PROCES - INSTANCE_NAME | Oracle monitoring: instance_name | ||
| 26 | GPG_TR_PROCES - INST_ID | Oracle monitor: Instance ID | ||
| 27 | GPG_TR_PROCES - PGA_ALLOC_MEM | Oracle monitoring: PGA memory allocated by the process | ||
| 28 | GPG_TR_PROCES - PGA_MAX_MEM | Oracle monitoring: Max PGA memory allocated by the process | ||
| 29 | GPG_TR_PROCES - PGA_USED_MEM | Oracle monitoring: PGA memory currently used by the process | ||
| 30 | GPG_TR_PROCES - PROGRAM_OS | Oracle monitoring: PROGRAM: Operating system program name | ||
| 31 | GPG_TR_PROCES - SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ||
| 32 | GPG_TR_PROCES - STATUS | Oracle monitoring: Current process status | ||
| 33 | GPG_TR_SQLOMP - ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ||
| 34 | GPG_TR_SQLOMP - HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ||
| 35 | GPG_TR_SQLOMP - INSTANCE_NAME | Oracle monitoring: instance_name | ||
| 36 | GPG_TR_SQLOMP - INST_ID | Oracle monitor: Instance ID | ||
| 37 | GPG_TR_SQLOMP - MPASS_CNT | Oracle Monitoring: MULTIPASSES_EXECUTIONS | ||
| 38 | GPG_TR_SQLOMP - MPASS_PERC | GPG_TR_SQLOMP-MPASS_PERC | ||
| 39 | GPG_TR_SQLOMP - ONEPASS_CNT | Oracle Monitoring: ONEPASS_EXECUTIONS | ||
| 40 | GPG_TR_SQLOMP - ONEPASS_PERC | GPG_TR_SQLOMP-ONEPASS_PERC | ||
| 41 | GPG_TR_SQLOMP - OPTIMAL_CNT | Oracle Monitoring: OPTIMAL_EXECUTIONS | ||
| 42 | GPG_TR_SQLOMP - OPTIMAL_PERC | GPG_TR_SQLOMP-OPTIMAL_PERC | ||
| 43 | GPG_TR_SQLOMP - SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ||
| 44 | GPG_TR_SQLOMP - TOTAL_EXECUTIONS | Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass | ||
| 45 | GPG_TR_SQLTEXT - ADDRESS | Oracle monitoring: ADDRESS: Address of a cursor | ||
| 46 | GPG_TR_SQLTEXT - COMMAND_TYPE | Oracle monitoring: COMMAND_TYPE: Code for the type of SQL | ||
| 47 | GPG_TR_SQLTEXT - HASH_VALUE | Oracle monitoring: HASH_VALUE: Cursor hash | ||
| 48 | GPG_TR_SQLTEXT - INSTANCE_NAME | Oracle monitoring: instance_name | ||
| 49 | GPG_TR_SQLTEXT - INST_ID | Oracle monitor: Instance ID | ||
| 50 | GPG_TR_SQLTEXT - PIECE | Oracle monitoring: PIECE: Seq. No of SQL pieces | ||
| 51 | GPG_TR_SQLTEXT - SQL_TEXT | Oracle monitoring: SQL_TEXT: A column containing 1 SQL Text | ||
| 52 | GPG_TR_SQLWOA - ACTIVE_TIME | Oracle Monitoring: ACTIVE_TIME: Average Active Time | ||
| 53 | GPG_TR_SQLWOA - ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ||
| 54 | GPG_TR_SQLWOA - CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ||
| 55 | GPG_TR_SQLWOA - ESTIMATED_ONEPAS | Oracle Monitoring: ESTIMATED_ONEPASS_SIZE | ||
| 56 | GPG_TR_SQLWOA - ESTIMATED_OPTIMA | Oracle Monitoring: ESTIMATED_OPTIMAL_SIZE | ||
| 57 | GPG_TR_SQLWOA - HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ||
| 58 | GPG_TR_SQLWOA - INSTANCE_NAME | Oracle monitoring: instance_name | ||
| 59 | GPG_TR_SQLWOA - INST_ID | Oracle monitor: Instance ID | ||
| 60 | GPG_TR_SQLWOA - LAST_DEGREE | Oracle Monitoring: LAST_DEGREE: Deg of Parallelism of last | ||
| 61 | GPG_TR_SQLWOA - LAST_EXECUTION | Oracle Monitoring: LAST_EXECUTION | ||
| 62 | GPG_TR_SQLWOA - LAST_MEMORY_USED | Oracle Monitoring: LAST_MEMORY_USED: Mem used for last exec | ||
| 63 | GPG_TR_SQLWOA - LAST_TEMPSEG_SIZ | Oracle Monitoring: LAST_TEMPSEG_SIZE | ||
| 64 | GPG_TR_SQLWOA - MAX_TEMPSEG_SIZE | Oracle Monitoring: MAX_TEMPSEG_SIZE | ||
| 65 | GPG_TR_SQLWOA - MULTIPASSES_EXEC | Oracle Monitoring: MULTIPASSES_EXECUTIONS | ||
| 66 | GPG_TR_SQLWOA - ONEPASS_EXECUTIO | Oracle Monitoring: ONEPASS_EXECUTIONS | ||
| 67 | GPG_TR_SQLWOA - OPERATION_ID | Oracle Monitoring: OPERATION_ID | ||
| 68 | GPG_TR_SQLWOA - OPERATION_TYPE | Oracle Monitoring: OPERATION_TYPE | ||
| 69 | GPG_TR_SQLWOA - OPTIMAL_EXECUTIO | Oracle Monitoring: OPTIMAL_EXECUTIONS | ||
| 70 | GPG_TR_SQLWOA - POLICY | Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) | ||
| 71 | GPG_TR_SQLWOA - TOTAL_EXECUTIONS | Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass | ||
| 72 | GPG_TR_SQLWOA - WORKAREA_ADDRESS | Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle | ||
| 73 | GPG_TR_WOAACT - ESIZE | Oracle Monitoring: EXPECTED_SIZE | ||
| 74 | GPG_TR_WOAACT - INSTANCE_NAME | Oracle monitoring: instance_name | ||
| 75 | GPG_TR_WOAACT - INST_ID | Oracle monitor: Instance ID | ||
| 76 | GPG_TR_WOAACT - MAX_MEM | Oracle Monitoring: MAX_MEM_USED | ||
| 77 | GPG_TR_WOAACT - MEM | Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used | ||
| 78 | GPG_TR_WOAACT - OPERATION | Oracle Monitoring: OPERATION_TYPE | ||
| 79 | GPG_TR_WOAACT - PASS | Oracle Monitoring: NUMBER_PASSES | ||
| 80 | GPG_TR_WOAACT - SID | Oracle monitoring: SID | ||
| 81 | GPG_TR_WOAACT - SQL | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ||
| 82 | GPG_TR_WOAACT - TSIZE | Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment | ||
| 83 | GPG_TR_WOAEXE - INSTANCE_NAME | Oracle monitoring: instance_name | ||
| 84 | GPG_TR_WOAEXE - INST_ID | Oracle monitor: Instance ID | ||
| 85 | GPG_TR_WOAEXE - NAME | Oracle monitoring: Name | ||
| 86 | GPG_TR_WOAEXE - PERC | GPG_TR_WOAEXE-PERC | ||
| 87 | GPG_TR_WOAEXE - VALUE | oracle monitor: value | ||
| 88 | ORA_PG_PEROPT - INSTANCE_NAME | SDD - Oracle lock monitor: INSTNAME | ||
| 89 | ORA_PG_PEROPT - INST_ID | SDD - Oracle lock monitor: Instance ID | ||
| 90 | ORA_PG_PEROPT - MP_EXECUTIONS | SDD - Oracle lock monitor: MPE | ||
| 91 | ORA_PG_PEROPT - MP_PERC | SDD - Oracle lock monitor: MPP | ||
| 92 | ORA_PG_PEROPT - ONEPASS_EXECUTIO | SDD - Oracle lock monitor: ONE | ||
| 93 | ORA_PG_PEROPT - ONEPASS_PERC | SDD - Oracle lock monitor: ONP | ||
| 94 | ORA_PG_PEROPT - OPTIMAL_EXECUTIO | SDD - Oracle lock monitor: OPE | ||
| 95 | ORA_PG_PEROPT - OPTIMAL_PERC | SDD - Oracle lock monitor: OPP | ||
| 96 | ORA_PG_PEROPT - TOTAL_EXECUTIONS | SDD - Oracle lock monitor: OPT | ||
| 97 | ORA_PG_PGAADV - ESTD_OVERALLOC_C | SDD - Oracle PGA monitor: OverallocationCount | ||
| 98 | ORA_PG_PGAADV - ESTD_PGA_CACHE_H | SDD - Oracle PGA monitor: Cache Hits | ||
| 99 | ORA_PG_PGAADV - INSTANCE_NAME | SDD - Oracle lock monitor: INSTNAME | ||
| 100 | ORA_PG_PGAADV - INST_ID | SDD - Oracle lock monitor: Instance ID | ||
| 101 | ORA_PG_PGAADV - PGA_TARGET_FOR_E | SDD - Oracle PGA monitor: Target For Estimate | ||
| 102 | ORA_PG_PGAHIS - ESTD_MPS_CNT | SDD - Oracle lock monitor: MPE | ||
| 103 | ORA_PG_PGAHIS - ESTD_ONE_CNT | SDD - Oracle lock monitor: ONE | ||
| 104 | ORA_PG_PGAHIS - ESTD_OPT_CNT | SDD - Oracle lock monitor: OPE | ||
| 105 | ORA_PG_PGAHIS - HIGH_KB | SDD - Oracle PGA monitor: HIGHKB | ||
| 106 | ORA_PG_PGAHIS - INSTANCE_NAME | SDD - Oracle lock monitor: INSTNAME | ||
| 107 | ORA_PG_PGAHIS - INST_ID | SDD - Oracle lock monitor: Instance ID | ||
| 108 | ORA_PG_PGAHIS - LOW_KB | SDD - Oracle PGA monitor: LOWKB | ||
| 109 | ORA_PG_PGAHIS - PGA_TARGET_FACTO | SDD - Oracle PGA monitor: Target For Estimate | ||
| 110 | ORA_PG_PROCES - ADDRESS | SDD - Oracle lock monitor: SQLADDR | ||
| 111 | ORA_PG_PROCES - HASH_VALUE | SDD - Oracle lock monitor: SQLHASH | ||
| 112 | ORA_PG_PROCES - INSTANCE_NAME | SDD - Oracle lock monitor: INSTNAME | ||
| 113 | ORA_PG_PROCES - INST_ID | SDD - Oracle lock monitor: Instance ID | ||
| 114 | ORA_PG_PROCES - PGA_ALLOC_MEM | SDD - Oracle PGA monitor: ALLOCMEM | ||
| 115 | ORA_PG_PROCES - PGA_MAX_MEM | SDD - Oracle PGA monitor: MAXMEM | ||
| 116 | ORA_PG_PROCES - PGA_USED_MEM | SDD - Oracle PGA monitor: USEDMEM | ||
| 117 | ORA_PG_PROCES - PROGRAM_OS | SDD - Oracle PGA monitor: PGMOS | ||
| 118 | ORA_PG_PROCES - SQL_TEXT | SDD - Oracle lock monitor: SQLTEXT | ||
| 119 | ORA_PG_PROCES - STATUS | SDD - Oracle PGA monitor: STATUS | ||
| 120 | ORA_PG_SQLOMP - ADDRESS | SDD - Oracle lock monitor: SQLADDR | ||
| 121 | ORA_PG_SQLOMP - HASH_VALUE | SDD - Oracle lock monitor: SQLHASH | ||
| 122 | ORA_PG_SQLOMP - INSTANCE_NAME | SDD - Oracle lock monitor: INSTNAME | ||
| 123 | ORA_PG_SQLOMP - INST_ID | SDD - Oracle lock monitor: Instance ID | ||
| 124 | ORA_PG_SQLOMP - MPASS_CNT | SDD - Oracle lock monitor: OPE | ||
| 125 | ORA_PG_SQLOMP - MPASS_PERC | SDD - Oracle lock monitor: OPP | ||
| 126 | ORA_PG_SQLOMP - ONEPASS_CNT | SDD - Oracle lock monitor: OPE | ||
| 127 | ORA_PG_SQLOMP - ONEPASS_PERC | SDD - Oracle lock monitor: OPP | ||
| 128 | ORA_PG_SQLOMP - OPTIMAL_CNT | SDD - Oracle lock monitor: OPE | ||
| 129 | ORA_PG_SQLOMP - OPTIMAL_PERC | SDD - Oracle lock monitor: OPP | ||
| 130 | ORA_PG_SQLOMP - SQL_TEXT | SDD - Oracle lock monitor: SQLTEXT | ||
| 131 | ORA_PG_SQLOMP - TOTAL_EXECUTIONS | SDD - Oracle lock monitor: OPE | ||
| 132 | ORA_PG_SQLTEXT - ADDRESS | SDD - Oracle lock monitor: SQLADDR | ||
| 133 | ORA_PG_SQLTEXT - COMMAND_TYPE | SDD - Oracle PGA monitor: CMDTYPE | ||
| 134 | ORA_PG_SQLTEXT - HASH_VALUE | SDD - Oracle lock monitor: SQLHASH | ||
| 135 | ORA_PG_SQLTEXT - INSTANCE_NAME | SDD - Oracle lock monitor: INSTNAME | ||
| 136 | ORA_PG_SQLTEXT - INST_ID | SDD - Oracle lock monitor: Instance ID | ||
| 137 | ORA_PG_SQLTEXT - PIECE | SDD - Oracle PGA monitor: PIECE | ||
| 138 | ORA_PG_SQLTEXT - SQL_TEXT | SDD - Oracle PGA monitor: SQLTEXT | ||
| 139 | ORA_PG_SQLWOA - ACTIVE_TIME | SDD - Oracle PGA monitor: ACTTIME | ||
| 140 | ORA_PG_SQLWOA - ADDRESS | SDD - Oracle lock monitor: SQLADDR | ||
| 141 | ORA_PG_SQLWOA - CHILD_NUMBER | SDD - Oracle PGA monitor: CHILD | ||
| 142 | ORA_PG_SQLWOA - ESTIMATED_ONEPAS | SDD - Oracle PGA monitor: ESTDCNT | ||
| 143 | ORA_PG_SQLWOA - ESTIMATED_OPTIMA | SDD - Oracle PGA monitor: ESTDCNT | ||
| 144 | ORA_PG_SQLWOA - HASH_VALUE | SDD - Oracle lock monitor: SQLHASH | ||
| 145 | ORA_PG_SQLWOA - INSTANCE_NAME | SDD - Oracle lock monitor: INSTNAME | ||
| 146 | ORA_PG_SQLWOA - INST_ID | SDD - Oracle lock monitor: Instance ID | ||
| 147 | ORA_PG_SQLWOA - LAST_DEGREE | SDD - Oracle PGA monitor: LASTDEG | ||
| 148 | ORA_PG_SQLWOA - LAST_EXECUTION | SDD - Oracle PGA monitor: LASTEXEC | ||
| 149 | ORA_PG_SQLWOA - LAST_MEMORY_USED | SDD - Oracle PGA monitor: LASTMEM | ||
| 150 | ORA_PG_SQLWOA - LAST_TEMPSEG_SIZ | SDD - Oracle PGA monitor: LASTTMP | ||
| 151 | ORA_PG_SQLWOA - MAX_TEMPSEG_SIZE | SDD - Oracle PGA monitor: MAXTMP | ||
| 152 | ORA_PG_SQLWOA - MULTIPASSES_EXEC | SDD - Oracle lock monitor: OPE | ||
| 153 | ORA_PG_SQLWOA - ONEPASS_EXECUTIO | SDD - Oracle lock monitor: OPE | ||
| 154 | ORA_PG_SQLWOA - OPERATION_ID | SDD - Oracle PGA monitor: OPID | ||
| 155 | ORA_PG_SQLWOA - OPERATION_TYPE | SDD - Oracle PGA monitor: OPTYPE | ||
| 156 | ORA_PG_SQLWOA - OPTIMAL_EXECUTIO | SDD - Oracle lock monitor: OPE | ||
| 157 | ORA_PG_SQLWOA - POLICY | SDD - Oracle PGA monitor: POLICY | ||
| 158 | ORA_PG_SQLWOA - TOTAL_EXECUTIONS | SDD - Oracle lock monitor: OPE | ||
| 159 | ORA_PG_SQLWOA - WORKAREA_ADDRESS | SDD - Oracle PGA monitor: WOAADD | ||
| 160 | ORA_PG_WOAACT - ESIZE | SDD - Oracle PGA monitor: ESIZE | ||
| 161 | ORA_PG_WOAACT - INSTANCE_NAME | SDD - Oracle lock monitor: INSTNAME | ||
| 162 | ORA_PG_WOAACT - INST_ID | SDD - Oracle lock monitor: Instance ID | ||
| 163 | ORA_PG_WOAACT - MAX_MEM | SDD - Oracle PGA monitor: MEM | ||
| 164 | ORA_PG_WOAACT - MEM | SDD - Oracle PGA monitor: MEM | ||
| 165 | ORA_PG_WOAACT - OPERATION | SDD - Oracle PGA monitor: OPTYPE | ||
| 166 | ORA_PG_WOAACT - PASS | SDD - Oracle PGA monitor: PASS | ||
| 167 | ORA_PG_WOAACT - SID | SDD - Oracle lock monitor: SID | ||
| 168 | ORA_PG_WOAACT - SQL | SDD - Oracle lock monitor: SQLTEXT | ||
| 169 | ORA_PG_WOAACT - TSIZE | SDD - Oracle PGA monitor: TSIZE | ||
| 170 | ORA_PG_WOAEXE - INSTANCE_NAME | SDD - Oracle lock monitor: INSTNAME | ||
| 171 | ORA_PG_WOAEXE - INST_ID | SDD - Oracle lock monitor: Instance ID | ||
| 172 | ORA_PG_WOAEXE - NAME | SDD - Oracle PGA monitor: NAME | ||
| 173 | ORA_PG_WOAEXE - PERC | SDD - Oracle PGA monitor: PERCENTAGES | ||
| 174 | ORA_PG_WOAEXE - VALUE | SDD - Oracle PGA monitor: VALUE |