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