1 PACKAGE dbms_management_packs AUTHID DEFINER
2 IS
3
4 -------------------------------------------------------------------------------
5 -- PUBLIC CONSTANTS AND TYPES SECTION
6 -------------------------------------------------------------------------------
7
8 DIAGNOSTIC_PACK CONSTANT VARCHAR2(30) := 'DIAGNOSTIC';
9 TUNING_PACK CONSTANT VARCHAR2(30) := 'TUNING';
10
11 -------------------------------------------------------------------------------
12 -- PUBLIC PROCEDURES AND FUNCTIONS SECTION
13 -------------------------------------------------------------------------------
14
15 -- PROCEDURE DBMS_MANAGEMENT_PACKS.check_pack_enabled
16 -- PURPOSE: Check if pack license is declared to the system
17 -- via the system parameter "control_management_pack_license"
18 -- PARAMETERS:
19 -- PACK_NAME
20 -- The name of the pack (DIAGNOSTIC_PACK or TUNING_PACK)
21 -- NOTES: throws a user error if pack license not declared to the system.
22 PROCEDURE check_pack_enabled(pack_name IN varchar2);
23
24 -- FUNCTION DBMS_MANAGEMENT_PACKS.report
25 -- PURPOSE: Get a text report of what changes will be done to the system
26 -- if the "purge" procedure is called with a specific level.
27 -- PARAMETERS:
28 -- LICENSE_LEVEL
29 -- Any valid value for init.ora parameter
30 -- "control_management_pack_access". NULL is also a valid value,
31 -- and it is equivalent to using teh function with the current
32 -- value of the init.ora parameter.
33 -- RETURN: a clob containing a text explanation of the changes.
34 FUNCTION report(license_level IN varchar2) RETURN clob;
35
36 -- PROCEDURE DBMS_MANAGEMENT_PACKS.purge
37 -- PURPOSE: Remove/deactivate objects in the database that are inconsistent
38 -- with the proposed setting of the
39 -- "control_management_pack_access" parameter
40 -- PARAMETERS:
41 -- LICENSE_LEVEL
42 -- Any valid value for init.ora parameter
43 -- "control_management_pack_access". NULL is also a valid value,
44 -- and it is equivalent to using teh function with the current
45 -- value of the init.ora parameter.
46 PROCEDURE purge(license_level IN varchar2);
47
48 -- PROCEDURE DBMS_MANAGEMENT_PACKS.modify_awr_settings
49 -- PURPOSE: Modify the AWR snapshot settings.
50 -- PARAMETERS:
51 -- RETENTION
52 -- new retention time (in minutes). The specified value
53 -- must be in the range:
54 -- MIN_RETENTION (1 day) to
55 -- MAX_RETENTION (100 years)
56 --
57 -- If ZERO is specified, snapshots will be retained forever.
58 --
59 -- If NULL is specified, the old value for retention is preserved.
60 --
61 -- INTERVAL
62 -- The interval between each snapshot, in units of minutes.
63 -- The specified value must be in the range:
64 -- MIN_INTERVAL (10 minutes) to
65 -- MAX_INTERVAL (100 years)
66 --
67 -- If ZERO is specified, automatic and manual snapshots
68 -- will be disabled.
69 --
70 -- If NULL is specified, the current value is preserved.
71 PROCEDURE modify_awr_settings(retention IN NUMBER DEFAULT NULL,
72 interval IN NUMBER DEFAULT NULL);
73
74 -- PROCEDURE DBMS_MANAGEMENT_PACKS.purge_awr
75 -- PURPOSE: Purge all AWR data from the system.
76 PROCEDURE purge_awr;
77
78 END dbms_management_packs;
[Home] [Help]