PROCEDURE: SYS.DBMS_FEATURE_UTILITIES4

Source

1 PROCEDURE dbms_feature_utilities4
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 BEGIN
15   -- initialize
16   feature_info      := NULL;
17 
18   begin
19     select usecnt, encryptcnt, compresscnt, compressbas, compresslow,
20            compressmed, compresshgh
21       into feature_count, encryption_count, compression_count,
22            compressbas_count, compresslow_count, compressmed_count,
23            compresshgh_count
24       from sys.ku_utluse
25       where utlname = 'Oracle Utility External Table'
26       and   (last_used >=
27             (SELECT nvl(max(last_sample_date), sysdate-7)
28                FROM dba_feature_usage_statistics));
29   exception
30     when others then
31       null;
32   end;
33 
34   feature_usage := feature_usage || 'Oracle Utility External Table ' ||
35                    'invoked: ' || feature_count ||
36                    ' times, compression used: '      || compression_count ||
37                    ' times (BASIC algorithm used: '  || compressbas_count ||
38                    ' times, LOW algorithm used: '    || compresslow_count ||
39                    ' times, MEDIUM algorithm used: ' || compressmed_count ||
40                    ' times, HIGH algorithm used: '   || compresshgh_count ||
41                    ' times), encryption used: '      || encryption_count  ||
42                    ' times';
43 
44   feature_info := to_clob(feature_usage);
45 
46   feature_boolean := feature_count;
47   aux_count       := feature_count;
48 END dbms_feature_utilities4;