PROCEDURE: SYS.DBMS_FEATURE_UTILITIES1

Source

1 PROCEDURE dbms_feature_utilities1
2      ( feature_boolean  OUT  NUMBER,
3        aux_count        OUT  NUMBER,
4        feature_info     OUT  CLOB)
5 AS
6    feature_usage      VARCHAR2(1000) := NULL;
7    feature_count      NUMBER := 0;
8    compression_count  NUMBER := 0;
9    compressbas_count  NUMBER := 0;
10    compresslow_count  NUMBER := 0;
11    compressmed_count  NUMBER := 0;
12    compresshgh_count  NUMBER := 0;
13    encryption_count   NUMBER := 0;
14    encrypt128_count   NUMBER := 0;
15    encrypt192_count   NUMBER := 0;
16    encrypt256_count   NUMBER := 0;
17    encryptpwd_count   NUMBER := 0;
18    encryptdual_count  NUMBER := 0;
19    encrypttran_count  NUMBER := 0;
20    parallel_count     NUMBER := 0;
21    fulltts_count      NUMBER := 0;
22 BEGIN
23   -- initialize
24   feature_info      := NULL;
25 
26   -- Select stats from ku_utluse.
27   begin
28     select usecnt, encryptcnt, encrypt128, encrypt192, encrypt256,
29            encryptpwd, encryptdual, encrypttran, compresscnt,
30            compressbas, compresslow, compressmed, compresshgh, parallelcnt,
31            fullttscnt
32       into feature_count, encryption_count, encrypt128_count, encrypt192_count,
33            encrypt256_count, encryptpwd_count, encryptdual_count,
34            encrypttran_count, compression_count, compressbas_count,
35            compresslow_count, compressmed_count, compresshgh_count,
36            parallel_count, fulltts_count
37       from sys.ku_utluse
38      where utlname = 'Oracle Utility Datapump (Export)'
39        and   (last_used >=
40               (SELECT nvl(max(last_sample_date), sysdate-7)
41                  FROM dba_feature_usage_statistics));
42   exception
43     when others then
44       null;
45   end;
46 
47   feature_usage := feature_usage || 'Oracle Utility Datapump (Export) ' ||
48                 'invoked: ' || feature_count ||
49                 ' times, compression used: '      || compression_count ||
50                 ' times (BASIC algorithm used: '  || compressbas_count ||
51                 ' times, LOW algorithm used: '    || compresslow_count ||
52                 ' times, MEDIUM algorithm used: ' || compressmed_count ||
53                 ' times, HIGH algorithm used: '   || compresshgh_count ||
54                 ' times), encryption used: '      || encryption_count  ||
55                 ' times (AES128 algorithm used: ' || encrypt128_count  ||
56                 ' times, AES192 algorithm used: ' || encrypt192_count  ||
57                 ' times, AES256 algorithm used: ' || encrypt256_count  ||
58                 ' times, PASSWORD mode used: '    || encryptpwd_count  ||
59                 ' times, DUAL mode used: '        || encryptdual_count ||
60                 ' times, TRANSPARENT mode used: ' || encrypttran_count ||
61                 ' times), parallel used: '        || parallel_count    ||
62                 ' times, full transportable used: ' || fulltts_count   ||
63                 ' times';
64 
65   feature_info := to_clob(feature_usage);
66 
67   feature_boolean := feature_count;
68   aux_count       := feature_count;
69 END dbms_feature_utilities1;