1 package FND_PERFMON AUTHID CURRENT_USER as
2 /* $Header: AFPMMONS.pls 115.5 2003/08/22 19:25:09 fskinner ship $ */
3
4
5 --
6 -- SET_WAIT_SAMPLE_EXPIRATION
7 -- Set the number of days that wait_samples will be stored in the db.
8 -- Then delete expired samples.
9 --
10 procedure SET_WAIT_SAMPLE_EXPIRATION(new_expire float);
11
12 --
13 -- GET_WAIT_SAMPLE_EXPIRATION
14 -- Return the current expiration limit (ie: the number of days that
15 -- wait_samples will be stored in the db).
16 --
17 function GET_WAIT_SAMPLE_EXPIRATION return float;
18
19
20 --
21 -- TAKE_WAIT_SAMPLE
22 -- Sample v$session_wait to capture:
23 -- encoded event, background or foreground, batch or real-time, snapdate,
24 -- and group similar events so it records a count for the group.
25 --
26 procedure TAKE_WAIT_SAMPLE;
27
28
29
30
31
32 --
33 -- SET_SQL_SAMPLE_EXPIRATION
34 -- Set the number of days that sql_samples will be stored in the db.
35 -- Then delete expired samples.
36 --
37 procedure SET_SQL_SAMPLE_EXPIRATION(new_expire float);
38
39
40 --
41 -- GET_SQL_SAMPLE_EXPIRATION
42 -- Return the current expiration limit (ie: the number of days that
43 -- sql_samples will be stored in the db).
44 --
45 function GET_SQL_SAMPLE_EXPIRATION return float;
46
47
48 --
49 -- TAKE_SQL_SAMPLE
50 -- Sample v$session to capture
51 -- the sql currently being executed by every session.
52 --
53 procedure TAKE_SQL_SAMPLE;
54
55
56
57 end FND_PERFMON;
[Home] [Help]