PROCEDURE: SYS.DBMS_FEATURE_UTILITIES2

Source

1 PROCEDURE dbms_feature_utilities2
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    parallel_count     NUMBER := 0;
9    fulltts_count      NUMBER := 0;
10 BEGIN
11   -- initialize
12   feature_info := NULL;
13 
14   begin
15     select usecnt, parallelcnt, fullttscnt
16       into feature_count, parallel_count, fulltts_count
17       from sys.ku_utluse
18      where utlname = 'Oracle Utility Datapump (Import)'
19        and   (last_used >=
20               (SELECT nvl(max(last_sample_date), sysdate-7)
21                  FROM dba_feature_usage_statistics));
22   exception
23     when others then
24       null;
25   end;
26 
27   feature_usage := feature_usage || 'Oracle Utility Datapump (Import) ' ||
28                    'invoked: ' || feature_count ||
29                    ' times, parallel used: ' || parallel_count ||
30                    ' times, full transportable used: ' || fulltts_count ||
31                    ' times';
32 
33   feature_info := to_clob(feature_usage);
34 
35   feature_boolean := feature_count;
36   aux_count       := feature_count;
37 END dbms_feature_utilities2;