IBM E027SLL-H Troubleshooting Guide - Page 50
Resolving Oracle DB Agent problems - diagnostic actions, Resolving Oracle DB Agent problems -
![]() |
View all IBM E027SLL-H manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 50 highlights
Procedure 1. If you still have high CPU usage issues even after ensuring proper connectivity across firewalls, open a problem report with IBM Software Support or refer to the IBM Support Portal (http://www.ibm.com/support/entry/portal/ software). 2. For more information, see the "Firewalls" topics in the IBM Tivoli Monitoring Installation and Setup Guide. Resolving Oracle DB Agent problems - diagnostic actions Oracle DB Agent problems, such as a cursor performance problem can be resolved by setting an environment variable to disable problematic cursors. Procedure Diagnostic actions 1. Collect the detail traces of collector and RAS1 log. See the problem determination topics for enabling detailed tracing in the collector trace log and setting RAS trace parameters in the IBM Tivoli Monitoring for Databases: Oracle Agent User's Guide. 2. Identify the SQL query that caused the high CPU usage issues from the collector logs. 3. You can identify the SQL query that caused the high CPU usage issue from ITM Oracle Agent logs or the Oracle tools. Use the following procedure to identify the problematic cursors from ITM Oracle Agent logs: a. Open the collector logs and find CFE1645 messages. The messages show the return time of each cursors. For example: CFE1645T (165929) Time = 2008/06/06 16:59:29, collected records in 6 seconds. b. The default timeout value of ITM Oracle Agent is 45 seconds. If it takes more than 45 seconds, it might cause a timeout problem and Open Probe pipe error will be reported in the collector log. CFE1645T (170246) Time = 2008/06/06 17:02:46, collected records in 203 seconds c. When a timeout happens, review the previous cursor that executed before this message. For example: PDR3000T (170002) Deleting (1) rows for cursor DB6 RPF0300T (170002) Doing prep_l_fet for cursor DB6 ORU0085I (170002 ORU0090I (170002) Starting new SQL query. ORU0095I (170002) ORU0085I (170002 CAT1610I (170213) Dump of row 1 UPX0100T 000: 20202020 20202020 20202032 34313135 * 24115* 4. The previous cursor (DB6) took about 2 minutes and 11 seconds to return data causing the performance problem. 5. Were you able to identify an SQL query? v Yes: Continue to the corrective actions task. Resolving Oracle DB Agent problems - corrective actions Oracle DB agent problems, such as problematic cursors can be resolved by setting environment variables and overriding variable settings. 32 IBM Tivoli Monitoring: Troubleshooting Guide
-
1
-
2
-
3
-
4
-
5
-
6
-
7
-
8
-
9
-
10
-
11
-
12
-
13
-
14
-
15
-
16
-
17
-
18
-
19
-
20
-
21
-
22
-
23
-
24
-
25
-
26
-
27
-
28
-
29
-
30
-
31
-
32
-
33
-
34
-
35
-
36
-
37
-
38
-
39
-
40
-
41
-
42
-
43
-
44
-
45
-
46
-
47
-
48
-
49
-
50
-
51
-
52
-
53
-
54
-
55
-
56
-
57
-
58
-
59
-
60
-
61
-
62
-
63
-
64
-
65
-
66
-
67
-
68
-
69
-
70
-
71
-
72
-
73
-
74
-
75
-
76
-
77
-
78
-
79
-
80
-
81
-
82
-
83
-
84
-
85
-
86
-
87
-
88
-
89
-
90
-
91
-
92
-
93
-
94
-
95
-
96
-
97
-
98
-
99
-
100
-
101
-
102
-
103
-
104
-
105
-
106
-
107
-
108
-
109
-
110
-
111
-
112
-
113
-
114
-
115
-
116
-
117
-
118
-
119
-
120
-
121
-
122
-
123
-
124
-
125
-
126
-
127
-
128
-
129
-
130
-
131
-
132
-
133
-
134
-
135
-
136
-
137
-
138
-
139
-
140
-
141
-
142
-
143
-
144
-
145
-
146
-
147
-
148
-
149
-
150
-
151
-
152
-
153
-
154
-
155
-
156
-
157
-
158
-
159
-
160
-
161
-
162
-
163
-
164
-
165
-
166
-
167
-
168
-
169
-
170
-
171
-
172
-
173
-
174
-
175
-
176
-
177
-
178
-
179
-
180
-
181
-
182
-
183
-
184
-
185
-
186
-
187
-
188
-
189
-
190
-
191
-
192
-
193
-
194
-
195
-
196
-
197
-
198
-
199
-
200
-
201
-
202
-
203
-
204
-
205
-
206
-
207
-
208
-
209
-
210
-
211
-
212
-
213
-
214
-
215
-
216
-
217
-
218
-
219
-
220
-
221
-
222
-
223
-
224
-
225
-
226
-
227
-
228
-
229
-
230
-
231
-
232
-
233
-
234
-
235
-
236
-
237
-
238
-
239
-
240
-
241
-
242
-
243
-
244
-
245
-
246
-
247
-
248
-
249
-
250
-
251
-
252
-
253
-
254
-
255
-
256
-
257
-
258
-
259
-
260
-
261
-
262
-
263
-
264
-
265
-
266
-
267
-
268
-
269
-
270
-
271
-
272
-
273
-
274
-
275
-
276
-
277
-
278
-
279
-
280
-
281
-
282
-
283
-
284
-
285
-
286
-
287
-
288
-
289
-
290
-
291
-
292
-
293
-
294
-
295
-
296
-
297
-
298
-
299
-
300
-
301
-
302
-
303
-
304
-
305
-
306
-
307
-
308
-
309
-
310
![]() |
![]() |
![](/manual_guide/products/ibm-e027sllh-troubleshooting-guide-7c8d102/50.png)