1 PACKAGE fnd_oam_collection AUTHID CURRENT_USER AS
2 /* $Header: AFOAMCLS.pls 120.2.12000000.1 2007/01/18 13:22:04 appldev ship $ */
3
4 --
5 -- Name
6 -- update_metric_internal
7 -- Purpose
8 -- This procedure is for internal use only!
9 -- This procedure will update a row in fnd_oam_metval for the given
10 -- metric name.
11 --
12 -- Input Arguments
13 -- p_metric_name varchar2
14 -- p_value varchar2
15 -- p_status_code number : if < 0 then status_code is not updated.
16 --
17 -- Output Arguments
18 --
19 -- Input/Output Arguments
20 --
21 -- Notes:
22 -- This is an internal convenience method only for OAM collection
23 --
24 PROCEDURE update_metric_internal (
25 p_metric_name in varchar2,
26 p_value in varchar2,
27 p_status_code in number);
28
29 --
30 -- Name
31 -- refresh_activity
32 --
33 -- Purpose
34 -- Computes the values for the following indicators and updates the
35 -- FND_OAM_METVAL table using an autonomous transaction.
36 -- 1) Number of Active Users
37 -- 2) Number of Database sessions
38 -- 3) Number of Running requests
39 -- 4) Number of Service Processes
40 -- 5) Number of Serivces Up
41 -- 6) Number of Serivces Down
42 -- 7) Number of invalid objects
43 -- 8) % of Workflow mailer messages waiting to be sent
44 --
45 -- Input Arguments
46 --
47 -- Output Arguments
48 --
49 -- Notes:
50 --
51 --
52 PROCEDURE refresh_activity;
53
54 --
55 -- Name
56 -- refresh_config_changes
57 --
58 -- Purpose
59 -- Computes the values for the following indicators and updates the
60 -- FND_OAM_METVAL table using an autonomous transaction.
61 -- 1) Number of patches applied in the last 24 hours
62 -- 2) Number of changes in profile options in last 24 hours
63 --
64 -- Input Arguments
65 --
66 -- Output Arguments
67 --
68 -- Notes:
69 --
70 --
71 PROCEDURE refresh_config_changes;
72
73 --
74 -- Name
75 -- refresh_throughput
76 --
77 -- Purpose
78 -- Computes the values for the following indicators and updates the
79 -- FND_OAM_METVAL table using an autonomous transaction.
80 -- 1) % of Completed requests
81 -- 2) % of Workflow mailer messages that have been processed
82 --
83 -- Input Arguments
84 --
85 -- Output Arguments
86 --
87 -- Notes:
88 --
89 --
90 PROCEDURE refresh_throughput;
91
92 --
93 -- Name
94 -- refresh_exceptions_summary
95 --
96 -- Purpose
97 -- Computes the values for the following indicators and updates the
98 -- FND_OAM_METVAL table using an autonomous transaction.
99 -- 1) Number of critical unprocessed exceptions in last 24 hours
100 -- 2) Number of critical processed exceptions in last 24 hours
101 -- 3) Number of total critical unprocessed exceptions
102 --
103 -- Input Arguments
104 --
105 -- Output Arguments
106 --
107 -- Notes:
108 --
109 --
110 PROCEDURE refresh_exceptions_summary;
111
112 --
113 -- Name
114 -- refresh_user_alerts_summary
115 --
116 -- Purpose
117 -- Computes the values for the following indicators and updates the
118 -- fnd_oam_mets table using an autonomous transaction.
119 --
120 -- 1) Number of New User Alerts
121 -- 2) Number of New User Alert Occurrances
122 -- 3) Number of Open User Alerts
123 -- 4) Number of Open User Alert Occurrances
124 --
125 -- Input Arguments
126 --
127 -- Output Arguments
128 --
129 -- Notes:
130 --
131 --
132 PROCEDURE refresh_user_alerts_summary;
133
134 --
135 -- Name
136 -- refresh_miscellaneous
137 --
138 -- Purpose
139 -- Computes the values for the following indicators and
140 -- updates the FND_OAM_METVAL using an autonomous transaction.
141 -- Metrics: PL/SQL Agent, Servlet Agent, JSP Agent, JTF, Discoverer,
142 -- Personal Home Page, TCF
143 --
144 -- Input Arguments
145 --
146 -- Output Arguments
147 --
148 -- Notes:
149 --
150 --
151 PROCEDURE refresh_miscellaneous;
152
153 --
154 -- Name
155 -- refresh_app_sys_status
156 --
157 -- Purpose
158 -- Derives the status of the following applications servers using URL
159 -- pings of the corresponding processes that belong to the server. The status
160 -- and host information for each of the processes as well as servers are
161 -- updated in the FND_OAM_APP_SYS_STATUS table
162 -- 1) Admin - Currently no processes are defined for this server
163 -- 2) Web - Consists of Apache Server and Apache Listener
164 -- 3) Forms - Consists of the forms launcher
165 -- 4) CP - Consists of the Internal Concurrent Manager, Reports
166 -- 5) Data - Consists of the database instances as defined in gv$instance.
167 --
168 -- Input Arguments
169 --
170 -- Output Arguments
171 --
172 -- Notes:
173 --
174 --
175 PROCEDURE refresh_app_sys_status;
176
177 --
178 -- Name
179 -- raise_alerts
180 --
181 -- Purpose
182 -- Checks values for all metrics and service instances that are currently
183 -- being monitored and raises alert if the values or status codes match
184 -- the thresholds specified by the user.
185 --
186 -- Input Arguments
187 --
188 -- Output Arguments
189 --
190 -- Notes:
191 --
192 --
193 PROCEDURE raise_alerts;
194
195
196
197 --
198 -- Name
199 -- refresh_all
200 --
201 -- Purpose
202 -- Computes the values for all the indicators and updates the
203 -- fnd_sys_metrics table.
204 --
205 -- Input Arguments
206 --
207 -- Output Arguments
208 -- errbuf - for any error message
209 -- retcode - 0 for success, 1 for success with warnings, 2 for error
210 --
211 -- Notes:
212 --
213 --
214 PROCEDURE refresh_all (errbuf OUT NOCOPY VARCHAR2, retcode OUT NOCOPY VARCHAR2);
215
216 --
217 -- Name
218 -- submit_col_req_conditional
219 --
220 -- Purpose
221 -- Submits a request for program 'FNDOAMCOL' if and only if there are no
222 -- other requests for this program in the pending or running phase.
223 --
224 -- Input Arguments
225 --
226 -- Output Arguments
227 --
228 --
229 -- Notes:
230 --
231 --
232 PROCEDURE submit_col_req_conditional;
233
234 --
235 -- Name
236 -- resubmit
237 --
238 -- Purpose
239 -- Submits a request for program 'FNDOAMCOL' with the new repeat
240 -- interval if the current interval is different from the new repeat
241 -- interval.
242 --
243 -- It will cancel any pending or running requests before submitting
244 -- a new request.
245 --
246 -- If more than one repeating requests are found, it will cancel them
247 -- all and submit a new request with the given repeat interval.
248 --
249 --
250 -- Input Arguments
251 --
252 -- p_repeat_interval - The new repeat interval
253 -- p_repeat_interval_unit_code - The new repeat interval unit code
254 --
255 -- Output Arguments
256 -- p_ret_code
257 -- -1 - Was unable to cancel one or more in progress requests.
258 -- Check p_ret_msg for any error message.
259 -- -2 - There was no need to resubmit - since the currently
260 -- repeating request has the same repeat interval.
261 -- >0 - Successfully resubmitted. Request id of the new request.
262 --
263 -- p_ret_msg
264 -- Any return error message.
265 -- Notes:
266 --
267 --
268 PROCEDURE resubmit(
269 p_repeat_interval fnd_concurrent_requests.resubmit_interval%TYPE,
270 p_repeat_interval_unit_code fnd_concurrent_requests.resubmit_interval_unit_code%TYPE,
271 p_ret_code OUT NOCOPY number,
272 p_ret_msg OUT NOCOPY varchar2);
273
274
275 --
276 -- Name
277 -- Alert_Long_Running_Requests
278 --
279 -- Purpose
280 -- The procedure will raise a consolidated alert if more than a user specified threshold
281 -- number of concurrent requests are running for more than a user specified threshold offset
282 -- period of time and for more than a user specified threshold tolerance percentage of their
283 -- respective average runtimes. It also raise an alert for specified concurrent programs if it
284 -- runs for more than the user specified threshold tolerance percentage of its user specific
285 -- threshold offset period of time.
286
287 -- Input Arguments
288 --
289 -- None
290 --
291 -- Output Arguments
292 --
293 -- None
294 -- Notes:
295 --
296 --
297 PROCEDURE alert_long_running_requests;
298
299 --
300 -- Name
301 -- Alert_Long_Pending_Requests
302 --
303 -- Purpose
304 -- The procedure raises a consolidated alert if more than a user specified
305 -- threshold number of concurrent requests are pending for more than a user
306 -- specified threshold period of time after their requested start time.
307 -- It also raise an alert for specified concurrent programs if it is
308 -- pending for more than a user specified threshold period of time.
309 --
310 -- Input Arguments
311 --
312 -- None
313 --
314 -- Output Arguments
315 --
316 -- None
317 -- Notes:
318 --
319 --
320 PROCEDURE alert_long_pending_requests;
321
322
323
324 END fnd_oam_collection;