PROCEDURE: SYS.DBMS_FEATURE_PILLAR_EHCC

Source

1 PROCEDURE DBMS_FEATURE_PILLAR_EHCC
2      ( feature_boolean  OUT  NUMBER,
3        aux_count        OUT  NUMBER,
4        feature_info     OUT  CLOB)
5 AS
6   feature_count NUMBER;
7     feature_usage         varchar2(1000);
8 BEGIN
9   -- initialize
10   feature_info      := NULL;
11   feature_count     := 0;
12 
13   execute immediate 'select value from v$sysstat' ||
14     ' where name like ''EHCC Used on Pillar Tablespace'''
15     into feature_count;
16 
17   feature_usage := 'EHCC on Pillar: ' || to_char(feature_count);
18   feature_info := to_clob(feature_usage);
19 
20   if (feature_count > 0) then
21     feature_boolean := 1;
22   else
23     feature_boolean := 0;
24   end if;
25   aux_count       := feature_count;
26 end;