1 PACKAGE MGMT_DB_LL_METRICS AS
2
3 TYPE GenericCurType IS REF CURSOR;
4 /*
5 This is the version of the livelink package.
6 Update this if there is any change in the PL/SQL.
7 Its read by the configVersion.pl script to obtain the installed version
8 of the PL/SQL.
9 */
10 ORACLE_DATABASE_META_VER CONSTANT VARCHAR(17) := '10.3.7.0.2';
11 VERSION_817 CONSTANT VARCHAR(3) := '817';
12 VERSION_9i CONSTANT VARCHAR(3) := '9i';
13 VERSION_9iR2 CONSTANT VARCHAR(4) := '9iR2';
14 VERSION_10gR1 CONSTANT VARCHAR(5) := '10gR1';
15 VERSION_10gR2 CONSTANT VARCHAR(5) := '10gR2';
16 VERSION_11gR1 CONSTANT VARCHAR(5) := '11gR1';
17 VERSION_11gR2 CONSTANT VARCHAR(5) := '11gR2';
18 VERSION_12gR1 CONSTANT VARCHAR(5) := '12gR1';
19 MIN_SUPPORTED_VERSION CONSTANT VARCHAR2(10) := '08.1.7.0.0';
20 /*
21 Not Supported Version
22 */
23 NOT_SUPPORTED_VERSION CONSTANT VARCHAR(3) := 'NSV';
24 /*
25 Higher Supported Version
26 */
27 HIGHER_SUPPORTED_VERSION CONSTANT VARCHAR(3) := 'HSV';
28
29 /*
30 Puts the config data into the file
31 By default, this procedure does not raise an exception.
32 To raise an exception, pass "raise_exp" as TRUE.
33 */
34 procedure collect_config_metrics(directory_location IN VARCHAR2,
35 raise_exp BOOLEAN DEFAULT FALSE);
36
37 /*
38 Write some DB info to a file (for RAC discovery/ADR info collection)
39 By default, this procedure does not raise an exception.
40 To raise an exception, pass "raise_exp" as TRUE.
41 */
42 procedure write_db_ccr_file(directory_location IN VARCHAR2,
43 raise_exp BOOLEAN DEFAULT FALSE);
44
45 /*
46 Puts the statistics config data into the file
47 By default, this procedure does not raise an exception.
48 To raise an exception, pass "raise_exp" as TRUE.
49 */
50 procedure collect_stats_metrics(directory_location IN VARCHAR2,
51 raise_exp BOOLEAN DEFAULT FALSE);
52
53 /*
54 Compute the version category
55 */
56 FUNCTION get_version_category RETURN VARCHAR2;
57
58 END MGMT_DB_LL_METRICS;
[Home] [Help]