Oracle Feature Usage Procedures
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose These procedures support Oracle's Feature Usage Reporting: See link at page bottom.
AUTHID DEFINER
First Available 11.2
Security Model Owned by SYS with no privileges granted
Source Code {ORACLE_HOME}/rdbms/admin/catfusrg.sql
{ORACLE_HOME}/rdbms/admin/catsnmp.sql
 
DBMS_FEATURE_ACFS
Dependencies
DUAL GV$ASM_FILESYSTEM SYS_STUB_FOR_PURITY_ANALYSIS
Detects ACFS usage dbms_feature_acfs(
is_used      OUT NUMBER,
aux_count    OUT NUMBER,
feature_info OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_acfs(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3: :num_filesystems:0
 
DBMS_FEATURE_ACFS_ENCR
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS V$ASM_ACFS_ENCRYPTION_INFO  
Detects ACFS Encryption usage dbms_feature_acfs_encr(
is_used      OUT NUMBER,
aux_count    OUT NUMBER,
feature_info OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_acfs_encr(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_ACFS_SNAPSHOT
Dependencies
V$ASM_ACFSSNAPSHOTS SYS_STUB_FOR_PURITY_ANALYSIS  
Detects ACFS Snapshots usage dbms_feature_acfs_snapshot(
is_used      OUT NUMBER,
aux_count    OUT NUMBER,
feature_info OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_acfs_snapshot(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3: :num_snapshots:0
 
DBMS_FEATURE_ACTIVE_DATA_GUARD
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects Active Data Guard usage dbms_feature_active_data_guard(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_active_data_guard(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Active Data Guard usage not detected
 
DBMS_FEATURE_ADAPTIVE_PLANS
Dependencies
DBMS_LOB V$SQL X$KSPPCV
SYS_STUB_FOR_PURITY_ANALYSIS V$SQLCOMMAND X$KSPPI
Tracks Adaptive Execution Plan usage dbms_feature_adaptive_plans(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_adaptive_plans(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2:
3: Total number of queries: 15691
Number of queries with an adaptive plan: 1512
Percentage of queries with an adaptive plan: 9.63609712574087056274297367917914728188
Are the queries
running in reporting mode ? : No

PL/SQL procedure successfully completed.
 
DBMS_FEATURE_ADBDCAT (new 23ai)
Dependencies
DBA_FEATURE_USAGE_STATISTICS JSON_ARRAY_T JSON_OBJECT_T
DBA_TABLES JSON_ELEMENT_T SYS_STUB_FOR_PURITY_ANALYSIS
DUAL    
Data Catalog Integration in Autonomous Database dbms_feature_adbdcat(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_adbdcat(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_ADBXTTAB (new 23ai)
Dependencies
ALL_EXTERNAL_LOCATIONS DBA_USERS JSON_ELEMENT_T
ALL_XTERNAL_LOC_PARTITIONS DBA_XTERNAL_TAB_PARTITIONS JSON_OBJECT_T
DBA_EXTERNAL_TABLES DUAL PLITBLM
DBA_TABLES JSON_ARRAY_T SYS_STUB_FOR_PURITY_ANALYSIS
External Tables

Testing in multiple versions repeatedly demonstrates that there can be hundreds of external tables and the result set produced by the anonymous block returns nothing of value.		 dbms_feature_adbxttab(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_adbxttab(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_ADV_IDXCMP
Dependencies
PRVT_COMPRESSION SYS_STUB_FOR_PURITY_ANALYSIS  
Detect Advanced Index Compression usage dbms_feature_adv_idxcmp(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_adv_idxcmp(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: ADVANCED Index Compression not detected
 
DBMS_FEATURE_ADV_TABCMP
Dependencies
PRVT_COMPRESSION SYS_STUB_FOR_PURITY_ANALYSIS  
Detect Advanced Table Compression usage dbms_feature_adv_tabcmp(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_adv_tabcmp(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: ADVANCED Table Compression Not Detected
 
DBMS_FEATURE_AFD
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS V$ASM_DISK  
Detects ASM Filter Driver usage dbms_feature_afd(
is_used      OUT NUMBER,
aux_count    OUT NUMBER,
feature_info OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_afd(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_APEX
Dependencies
DBA_REGISTRY DBMS_STANDARD SYS_STUB_FOR_PURITY_ANALYSIS
DBMS_ASSERT    
Detects APEX usage dbms_feature_apex(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_apex(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: APEX usage not detected
 
DBMS_FEATURE_APPROX_QP
Dependencies
GV$SQL_PLAN SYS_STUB_FOR_PURITY_ANALYSIS  
Detects Approximate Query Processing dbms_feature_approx_qp(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_approx_qp(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2:
3: approx_count_distinct: USED
 
DBMS_FEATURE_ASM
Dependencies
DUAL V$ASM_CLIENT V$ASM_DISKGROUP
SYS_STUB_FOR_PURITY_ANALYSIS V$ASM_DISK  
Detects ASM usage dbms_feature_asm(
is_used              OUT NUMBER,
total_diskgroup_size OUT NUMBER,
summary              OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_asm(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_AUDIT_OPTIONS
Dependencies
AUDIT$ SYS_STUB_FOR_PURITY_ANALYSIS V$PARAMETER
DBA_OBJ_AUDIT_OPTS V$OPTION  
Detects audit trail type and the number of system and object audit options available dbms_feature_audit_options(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_audit_options(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 0
3: AUDIT_TRAIL=DB; Number of system audit options=234; Number of object audit options=254
 
DBMS_FEATURE_AUM
Dependencies
DBA_DATA_FILES DBA_TABLESPACES V$SYSTEM_PARAMETER
DBA_FEATURE_USAGE_STATISTICS SYS_STUB_FOR_PURITY_ANALYSIS V$UNDOSTAT
Detects Automatic Undo Management usage dbms_feature_aum(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_aum(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 1
3: (Retention: NOGUARANTEE, TS Count: 1, Size MB: 25) (Undo Blocks: 62345, Max Concurrency: 6) (Snapshot Old Info - Begin Time: 2020-12-03 18:43:59, End Time: 2020-12-07 18:41:11,
SSOLD Error Count: 0)
 
DBMS_FEATURE_AUTOSTA
Dependencies
DBA_ADVISOR_EXECUTIONS DBA_ADVISOR_RECOMMENDATIONS DBMS_LOB
DBA_ADVISOR_EXEC_PARAMETERS DBA_FEATURE_USAGE_STATISTICS DBMS_STANDARD
DBA_ADVISOR_FINDINGS DBA_SQL_PROFILES SYS_STUB_FOR_PURITY_ANALYSIS
DBA_ADVISOR_OBJECTS    
Detects auto-implemented SQL profiles usage dbms_feature_autosta(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_autosta(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 1
3: Execution count so far: 8, Executions with auto-implement: 0, SQL profiles recommended so far: 1, Projected DB Time Saved Automatically (s): 0
 
DBMS_FEATURE_AUTO_MEM
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS V$MEMORY_TARGET_ADVICE V$SYSTEM_EVENT
V$MEMORY_DYNAMIC_COMPONENTS V$PGASTAT  
Detects Automatic Memory Management usage dbms_feature_auto_mem(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_auto_mem(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 0
3:
:memory_target:1291845632:sga_max_size:780140544:memory_max_target:1291845632:co
mp:shared pool:cur:369098752:min:369098752:max:369098752:usr:0:comp:large
pool:cur:8388608:min:8388608:max:8388608:usr:0:comp:java
pool:cur:25165824:min:8388608:max:25165824:usr:0:comp:streams
pool:cur:8388608:min:8388608:max:8388608:usr:0:comp:SGA
Target:cur:780140544:min:780140544:max:780140544:usr:0:comp:DEFAULT buffer
cache:cur:360710144:min:360710144:max:377487360:usr:0:comp:PGA
Target:cur:511705088:min:511705088:max:511705088:usr:0:mem tgt
adv::msz:616:sf:.5:time:941:tf:1.0053:msz:924:sf:.75:time:936:tf:1.0004:msz:1232
:sf:1:time:936:tf:1:msz:1540:sf:1.25:time:936:tf:1:msz:1848:sf:1.5:time:936:tf:1
:msz:2156:sf:1.75:time:936:tf:1:msz:2464:sf:2:time:936:tf:1:event:SGA:
allocation:waits:2:time:3
 
DBMS_FEATURE_AUTO_REOPT
Dependencies
DBMS_LOB V$SQL X$KSPPCV
SYS_STUB_FOR_PURITY_ANALYSIS V$SQLCOMMAND X$KSPPI
Track Adaptive Reoptimization usage dbms_feature_auto_reopt(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_auto_reopt(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2:
3: Total number of queries: 15694
Number of reoptimizable queries: 7
Percentage of reoptimizable queries: .0446030330062444246208742194469223907226
 
DBMS_FEATURE_AUTO_SGA
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS V$MEMORY_DYNAMIC_COMPONENTS V$SYSTEM_EVENT
Detects Automatic SGA Management usage dbms_feature_auto_sga(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_auto_sga(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Automatic SGA Tuning usage not detected
 
DBMS_FEATURE_AUTO_SSM
Dependencies
DBA_DATA_FILES DBA_TABLESPACES SYS_STUB_FOR_PURITY_ANALYSIS
Detects Automatic Segment Space Managed tablespaces usage dbms_feature_auto_ssm(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_auto_ssm(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 4
3: (Segment Space Management: MANUAL, TS Count: 2, Size MB: 955) (Segment Space Management: AUTO, TS Count: 2, Size MB: 1315)
 
DBMS_FEATURE_AWR
Dependencies
DBA_HIST_SNAPSHOT WRH$_STAT_NAME WRI$_DBU_USAGE_SAMPLE
SYS_STUB_FOR_PURITY_ANALYSIS WRH$_SYS_TIME_MODEL WRM$_SNAPSHOT
V$DATABASE    
Counts snapshots since last sample also counts DB time and DB cpu over last 7 days dbms_feature_awr(
feature_boolean_out OUT NUMBER,
aux_count_out       OUT NUMBER,
feature_info_out    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_awr(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3: DBtime:1736.79,DBcpu:1454.66
 
DBMS_FEATURE_BACKUP_ENCRYPTION
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Counts RMAN Backup Encryption usage dbms_feature_backup_encryption(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_backup_encryption(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_BA_OWNER
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of the Oracle Database Logging Recovery Appliance (ZDLRA - see link at page bottom) dbms_feature_ba_owner(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
info            OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_ba_owner(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_CHARSET (new 23ai)
Dependencies
DBA_FEATURE_USAGE_STATISTICS JSON_ELEMENT_T SYS_STUB_FOR_PURITY_ANALYSIS
DUAL JSON_OBJECT_T V$NLS_PARAMETERS
JSON_ARRAY_T    
Character Sets dbms_feature_charset(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_charset(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 0
3: {"name":"Character Set","value":[
   {"name":"NLS_CHARACTERSET","value":"AL32UTF8"},
   {"name":"NLS_NCHAR_CHARACTERSET","value":"AL16UTF16"}]}
 
DBMS_FEATURE_CLOUD_EHCC
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects EHCC in Cloud Database usage dbms_feature_cloud_ehcc(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_cloud_ehcc(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: EHCC in Cloud Database: 0
 
DBMS_FEATURE_CONCURRENT_STATS
Dependencies
DBA_OPTSTAT_OPERATIONS DBMS_STATS SYS_STUB_FOR_PURITY_ANALYSIS
DBMS_LOB DUAL XMLTYPE
Track concurrent stats gathering usage dbms_feature_concurrent_stats(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_concurrent_stats(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Time interval covered by dba_optstat_operations: 11/17/2020 - 12/06/2020
Total Number of All Stats Operations: 297
Total Number of Gather Stats Operations: 209
Total Number of Concurrent Operations: 0.
Types of concurrent operations with their frequencies:
Current value of CONCURRENT preference: OFF
 
DBMS_FEATURE_DATABASE_ODM
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS V$OPTION  
Detects Oracle Data Mining usage dbms_feature_database_odm(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_database_odm(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_DATABASE_VAULT
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS USER$ V$OPTION
Detects Database Vault usage dbms_feature_database_vault(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_database_vault(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_DATA_GUARD
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects Data Guard usage dbms_feature_data_guard(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_data_guard(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Data Guard usage not detected
 
DBMS_FEATURE_DATA_REDACTION
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects Data Redaction usage dbms_feature_data_redaction(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_data_redaction(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Data Redaction usage not detected
 
DBMS_FEATURE_DBC (new 23ai)
Dependencies
DBA_OBJECTS JSON_ARRAY_T PLITBLM
DBA_TAB_COLUMNS JSON_ELEMENT_T SYS_STUB_FOR_PURITY_ANALYSIS
DBA_USERS JSON_OBJECT_T  
Data Bound Collation dbms_feature_dbc(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_dbc(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_DBFS_CONTENT
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of DBFS_CONTENT to display the path items from all available content stores dbms_feature_dbfs_content(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_dbfs_content(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: DBFS Content feature not in use.
 
DBMS_FEATURE_DBFS_HS
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of DBFS_HS (hierarchical) content stores dbms_feature_dbfs_hs(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_dbfs_hs(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: DBFS HS feature not in use.
 
DBMS_FEATURE_DBFS_SFS
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of DBFS content storage administration sample implementation dbms_feature_dbfs_sfs(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_dbfs_sfs(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: DBFS SFS feature is not in use.
 
DBMS_FEATURE_DEFERRED_SEG_CRT
Dependencies
IND$ LOBFRAG$ TABPART$
INDPART$ SEG$ TABSUBPART$
INDSUBPART$ SYS_STUB_FOR_PURITY_ANALYSIS V$SYSTEM_PARAMETER
LOB$ TAB$  
Detects usage of Deferred Segment Creation dbms_feature_deferred_seg_crt(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_deferred_seg_crt(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 2
2: 783
3: Deferred Segment Creation Parameter:1 Total Deferred Segments:783 Total Created Segments:7673 Table Segments:294 Index Segments:399 Lob Segments:82 Table Partition Segments:2
Index Partition Segments:3 Lob Partition Segments:3 Table SubPartition Segments:0 Index SubPartition Segments:0 Lob SubPartition Segments:0
 
DBMS_FEATURE_DMU
Dependencies
PROPS$ SYS_STUB_FOR_PURITY_ANALYSIS WRI$_DBU_USAGE_SAMPLE
Reports usage of Oracle Database Migration Assistant for Unicode dbms_feature_dmu(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_dmu(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: DMU usage not detected
 
DBMS_FEATURE_DYN_SGA
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS V$MEMORY_DYNAMIC_COMPONENTS V$SYSTEM_EVENT
Detects usage of Dynamic SGA dbms_feature_dyn_sga(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_dyn_sga(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Dynamic SGA usage not detected
 
DBMS_FEATURE_EM_DIAG (new 23ai)
Dependencies
DBMS_FEATURE_EM_INT SYS_STUB_FOR_PURITY_ANALYSIS  
DBSNMP Feature Log Source last update date for the source 'Diagnostic' dbms_feature_em_diag(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  dbsnmp.dbms_feature_em_diag(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_EM_GC (new 23ai)
Dependencies
DBMS_FEATURE_EM_INT SYS_STUB_FOR_PURITY_ANALYSIS  
DBSNMP Feature Log Source last update date for the source 'GC' dbms_feature_em_gc(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  dbsnmp.dbms_feature_em_gc(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_EM_INT (new 23ai)
Dependencies
DBMS_FEATURE_EM_DIAG DBMS_FEATURE_EM_TUNING SYS_STUB_FOR_PURITY_ANALYSIS
DBMS_FEATURE_EM_GC MGMT_DB_FEATURE_LOG WRI$_DBI_USAGE_SAMPLE
DBSNMP Feature Log Source last update date for the specified source dbms_feature_em_int(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB,
l_source        IN  VARCHAR2);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
 l dbms_id := 'DMORGAN';
BEGIN
  dbsnmp.dbms_feature_em_int(i, j, k, l);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_EM_TUNING (new 23ai)
Dependencies
DBMS_FEATURE_EM_INT SYS_STUB_FOR_PURITY_ANALYSIS  
DBSNMP Feature Log Source last update date for the source 'Tuning' dbms_feature_em_tuning(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  dbsnmp.dbms_feature_em_tuning(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_EXADATA
Dependencies
DBMS_REGISTRY SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of Exadata storage dbms_feature_extadata(
feature_boolean OUT NUMBER,
num_cells       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_exadata(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: EXADATA usage not detected
 
DBMS_FEATURE_EXTENSIBILITY
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of Extensibility Features dbms_feature_extensibility(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_extensibility(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: EXTENSIBILITY usage not detected
 
DBMS_FEATURE_FGA_AUDIT
Dependencies
DBA_AUDIT_POLICIES SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of Fine Grained Auditing dbms_feature_fga_audit(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_fga_audit(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Number of FGA policies=0; Number of Enabled FGA policies=0; Number of FGA policies with audit_condition=0; Number of FGA policies with column-level audit=0; Number of FGA policies with handler=0; Number of FGA policies with DB audit_trail=0; Number of FGA policies with XML audit_trail=0
 
DBMS_FEATURE_FLEX_ASM
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of Flex ASM dbms_feature_flex_asm(
is_used      OUT NUMBER,
aux_count    OUT NUMBER,
feature_info OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_flex_asm(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_GATEWAYS
Dependencies
PLITBLM SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of Oracle database gateways dbms_feature_gateways(
feature_boolean OUT NUMBER,
num_cells       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_gateways(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: This feature is not used.
 
DBMS_FEATURE_GOLDENGATE
Dependencies
DBA_APPLY GV$GOLDENGATE_CAPABILITIES SYS_STUB_FOR_PURITY_ANALYSIS
DBA_CAPTURE    
Detects usage of Golden Gate Replication dbms_feature_goldengate(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_goldengate(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: tcap:0 dscap:0 app:0 dblogread:0 tdup:0 suptrig:0 dtrigopt:0
 
DBMS_FEATURE_HCC
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of Hybrid Columnar Compression dbms_feature_hcc(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_hcc(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Hybrid Columnar Compression not detected
 
DBMS_FEATURE_HCCCONV
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of Hybrid Columnar Compression Conventional Load dbms_feature_hccconv(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_hccconv(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Hybrid Columnar Compressed Conventional: 0
 
DBMS_FEATURE_HCCRLL
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detect usage of Hybrid Columnar Compression Row Level Locking dbms_feature_hccrll(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_hccrll(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Hybrid Columnar Compression Row Level Locking not detected
 
DBMS_FEATURE_HCS
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Tracks HCS PL/SQL logging dbms_feature_hcs(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_hcs(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_HEATMAP
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Tracks heatmap feature usage dbms_feature_heatmap(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_heatmap(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 0
3: Number of Tablespaces Traced: 1, Number of Segments Tracked: 1, Number of Blocks Tracked in Memory: 0
 
DBMS_FEATURE_IDH
Dependencies
DBA_ROLE_PRIVS SYS_STUB_FOR_PURITY_ANALYSIS  
Detect In-Database Hadoop usage dbms_feature_idh(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_idh(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: In-Database Hadoop usage not detected
 
DBMS_FEATURE_ILM
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects Information Lifecycle Management usage dbms_feature_ilm(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_ilm(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Information Lifecycle Management not detected
 
DBMS_FEATURE_IMA
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects In-Memory Aggregation usage dbms_feature_ima(
feature_boolean OUT NUMBER,
num_cells       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_ima(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: In-Memory Aggregation Not Detected
 
DBMS_FEATURE_IMC
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects In-Memory Column Store usage dbms_feature_imc(
feature_boolean OUT NUMBER,
num_cells       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_imc(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: In-Memory Column Store Not Detected
 
DBMS_FEATURE_IMFS
Dependencies
SYSDBIMFS$ SYS_STUB_FOR_PURITY_ANALYSIS V$TABLESPACE
SYSDBIMFS_METADATA$    
Detects usage of In-Memory Fast Start dbms_feature_imfs(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_imfs(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: In-Memory FastStart enabled on USERS: Current Number of Savepoints in FastStart Area: 0, Current Space Usage: , Total Number of Savepoints in FastStart Area:
 
DBMS_FEATURE_IM_ADO
Dependencies
ILMOBJ$ ILMPOLICY$ SYS_STUB_FOR_PURITY_ANALYSIS
Detects usage of In-Memory Automatic Data Optimization policies dbms_feature_im_ado(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_im_ado(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_IM_BASE_LEVEL
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects In-Memory Base Level usage dbms_feature_im_base_level(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_im_base_level(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: In-Memory Base Level Not Detected
 
DBMS_FEATURE_IM_EXPRESSIONS
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of In-Memory Expressions and Virtual Column usage dbms_feature_im_expressions(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_im_expressions(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_IM_FORSERVICE
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of In-Memory For Service usage dbms_feature_im_forservice(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_im_forservice(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_IM_JOINGROUPS
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of In-Memory Join Group usage dbms_feature_im_joingroups(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_im_joingroups(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_IOT
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects Index Organized Table usage dbms_feature_iot(
feature_boolean OUT NUMBER,
num_cells       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_iot(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Index Organized Tables Not Detected
 
DBMS_FEATURE_JOB_CLOUDSQL (new 23ai)
Dependencies
DBA_HIST_SNAPSHOT GV$SYSSTAT V$DATABASE
DBA_HIST_SYSSTAT SYS_STUB_FOR_PURITY_ANALYSIS  
CloudSQL dbms_feature_job_cloudsql(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_job_cloudsql(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_JOB_SCHEDULER
Dependencies
ALL_SCHEDULER_DB_DESTS DBA_SCHEDULER_CHAIN_STEPS DBA_SCHEDULER_JOB_CLASSES
ALL_SCHEDULER_EXTERNAL_DESTS DBA_SCHEDULER_CREDENTIALS DBA_SCHEDULER_NOTIFICATIONS
ALL_SCHEDULER_GROUPS DBA_SCHEDULER_DB_DESTS DBA_SCHEDULER_PROGRAMS
ALL_SCHEDULER_JOBS DBA_SCHEDULER_DESTS DBA_SCHEDULER_PROGRAM_ARGS
ALL_SCHEDULER_PROGRAMS DBA_SCHEDULER_FILE_WATCHERS DBA_SCHEDULER_SCHEDULES
DBA_JOBS DBA_SCHEDULER_GROUPS DBA_SCHEDULER_WINDOWS
DBA_SCHEDULER_CHAINS DBA_SCHEDULER_JOBS SYS_STUB_FOR_PURITY_ANALYSIS
Detects usage of Job Scheduler dbms_feature_job_scheduler(
is_used    OUT NUMBER,
nr_of_jobs OUT NUMBER,
summary    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_job_scheduler(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 4
2: 4
3:
JNRA:26,JNRU:4,DJOBS:0,JTDPLS:12,JTDPRO:5,JTDSTO:9,JTIPLS:13,JTISTO:13,JDSCAL:17
,JDSNAM:5,JDSONC:1,JDSWGR:3,JISCAL:22,JISONC:1,JISWGR:3,JAC:1,JAA:4,JAM:4,JAX:4,
JSTREG:26,JRS:26,JMRD:0,JSL:0,JII:0,JAR:0,JFLW:0,JRE:0,JDIS:5,JPI:0,PRTPLS:2,PRT
STO:8,PAC:2,PAA:11,PAM:11,PAX:12,SSTCAL:4,PAN:8,PA_:14,PMJNA:1,PMJOW:1,JCNT:14,J
CSV:0,JCCG:9,LLFAI:2,LLFUL:9,LLOFF:1,LLRUN:2,WIPLO:9,WINR:2,SWTCA:9,CCNT:0,CEVI:
,CURS:,CNRR:,CNRS:,CAVS:,CMDS:,CMXS:,CSRD:0,CRNR:0,CRDB:,CSWD:,DSDN:0,FWNR:0,FWS
S:,FWDS:,FWMF,GWINN:4,GWINA:7,GWINX:7,GWINM:7,SCHNRA:4,SCHNNR:4,CAFD:6,CAFH:8,CA
FM:1,CAFMI:5,CAFW:1,CAOF:0,CASC:0,CABS:0,CAIC:0,CAEX:0,CAIS:0,SNNR:0
 
DBMS_FEATURE_JSON
Dependencies
DBA_IND_EXPRESSIONS DBMS_LOB SYS_STUB_FOR_PURITY_ANALYSIS
DBMS_ASSERT DBMS_STANDARD  
Detects usage of JSON dbms_feature_json(
feature_boolean OUT NUMBER,
num_cells       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_json(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: { "version":1, "jsonColumns": {"total": , "varchar2": , "clob": , "blob": , "json": }, "rowCount": {"maxCount":0 , "minCount":0 , "avgCount":0 }, "rowSize": {"avgSizeBytes":0 ,
"maxSizeChars":0 }, "IMCStats": {"IMCU#":0 , "IMEU#":0 , "JSONIMC#":0 }, "views": {"total":0 , "jsonValue":0 , "jsonExists":0 , "jsonQuery":0 , "jsonTable":0 , "jsonDataGuide":0 },
"funcIdx": {"jsonValue":0 , "jsonExists":0 , "jsonQuery":0 }, "searchIdx": {"jsonSearchIdx":0 , "bsonSearchIdx":0 }, "dataguideStats": {"numDataguide":0 }, "sodaStats":
{"numCollections":0 } }
 
DBMS_FEATURE_LABEL_SECURITY
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects Label Security usage by making a call to lbacsys.feature_usage. dbms_feature_label_security(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_label_security(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: No. of policies=0
 
DBMS_FEATURE_LMT
Dependencies
DBA_DATA_FILES DBA_TABLESPACES SYS_STUB_FOR_PURITY_ANALYSIS
Detects usage of Locally Managed Tablespaces dbms_feature_lmt(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_lmt(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 4
3: (Extent Management: LOCAL, TS Count: 4, Size MB: 2400)
 
DBMS_FEATURE_MLE (new 23ai)
Dependencies
DBA_MLE_ENVS DUAL JSON_OBJECT_T
DBA_MLE_MODULES JSON_ELEMENT_T SYS_STUB_FOR_PURITY_ANALYSIS
DBMS_LOB    
MultiLingual Engine dbms_feature_mle(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_mle(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: {
  "Number of MLE modules" : 0,
  "Number of MLE envs" : 0
}
 
DBMS_FEATURE_MOVE_DATAFILE
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detect Online Move Datafile usage dbms_feature_move_datafile(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_move_datafile(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Online Move Datafile usage not detected
 
DBMS_FEATURE_OBJECT
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects the use of Object Types dbms_feature_object(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_object(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: OBJECT usage not detected
 
DBMS_FEATURE_ONLINE_REDEF
Dependencies
REDEF$ SYS_STUB_FOR_PURITY_ANALYSIS  
Detects use of the DBMS_REDEFINITION package dbms_feature_online_redef(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_object(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Online Redefinition usage not detected!
 
DBMS_FEATURE_PARTITION_SYSTEM
Dependencies
CLST$ INDSUBPART$ SUM$
CLSTJOIN$ OBJ$ SUMAGG$
CLSTKEY$ OPQTYPE$ SUMDETAIL$
COL$ PARTCOL$ SYS_STUB_FOR_PURITY_ANALYSIS
DEFSUBPART$ PARTOBJ$ TABCOMPART$
EXTERNAL_TAB$ SEG$ TABPART$
IND$ SNAP$ TABSUBPART$
INDCOMPART$ SUBPARTCOL$ USER$
INDPART$    
Detects system partitioning usage dbms_feature_partition_system(
is_used    OUT NUMBER,
data_ratio OUT NUMBER,
clob_rest  OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_partition_system(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 21.39
3:
1:T:INTERVAL::1048575-9::1::::|1:I:INTERVAL::1048575-9::1::L:NORMAL:NU|1:I:::::4::
...
RANGE::1::1::LP:NORMAL:NU|7RMAL:NU|79:I:RANGE::1::1::L:NORMAL:NU|79:I:
RANGE::1::1::L:LOB:U|
 
DBMS_FEATURE_PARTITION_USER
Dependencies
SEG$ SYS_STUB_FOR_PURITY_ANALYSIS TABPART$
Detects user partitioning usage dbms_feature_partition_user(
is_used    OUT NUMBER,
data_ratio OUT NUMBER,
clob_rest  OUT CLOB);
set serveroutput on

DECLARE
  2   i NUMBER;
  3   j NUMBER;
  4   k CLOB;
  5  BEGIN
  6   sys.dbms_feature_partition_user(i, j, k);
  7   dbms_output.put_line('1: ' || i);
  8   dbms_output.put_line('2: ' || j);
  9   dbms_output.put_line('3: ' || k);
 10 END;
 11 /
1: 1
2: 21.39
3:
1:T:RANGE::1::1::::|1:I:RANGE::1::1::L:NORMAL:NU|1:I:RANGE::1::1::L:LOB:U|1:I:
RANGE::1::1::L:NORMAL:P:NORMAL:NU|
 
DBMS_FEATURE_PILLAR_EHCC
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS V$SYSSTAT  
Detects Pillar Hybrid Columnar Compression use dbms_feature_pillar_ehcc(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_pillar_ehcc(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: EHCC on Pillar: 0
 
DBMS_FEATURE_PILLAR_STORAGE
Dependencies
KDZSTORAGETYPE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of Pillar Storage and returns the count and tablespace names dbms_feature_pillar_storage(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_pillar_storage(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: TS on Pillar: 0
 
DBMS_FEATURE_PLSQL_NATIVE
Dependencies
NCOMP_DLL$ SYS_STUB_FOR_PURITY_ANALYSIS V$SYSAUX_OCCUPANTS
OBJ$ USER$  
Detects PL/SQL native compilation usage dbms_feature_plsql_native(
o_is_used   OUT NUMBER,
o_aux_count OUT NUMBER,
o_report    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_plsql_native(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: <plsqlNativeReport date ="07-dec-2020 18:50">
<owner name="AUDSYS" interpreted="4"/>
<owner name="111" interpreted="2"/>
<owner name="CTXSYS" interpreted="177"/>
<owner name="37"
interpreted="2"/>
<owner name="DBSNMP" interpreted="19"/>
<owner name="106" interpreted="22"/>
<owner name="1279990" interpreted="135"/>
<owner name="22" interpreted="78"/>
<owner
name="104" interpreted="98"/>
<owner name="MDSYS" interpreted="845"/>
<owner name="OLAPSYS" interpreted="2"/>
<owner name="42" interpreted="6"/>
<owner name="ORDPLUGINS"
interpreted="10"/>
<owner name="ORDSYS" interpreted="547"/>
<owner name="13" interpreted="1"/>
<owner name="36" interpreted="13"/>
<owner name="SYS" interpreted="3797"/>
<owner
name="SYSTEM" interpreted="18"/>
<owner name="WMSYS" interpreted="116"/>
<owner name="XDB" interpreted="251"/>
</plsqlNativeReport>
 
DBMS_FEATURE_PRIV_CAPTURE
Dependencies
CAPTURE_RUN_LOG$ PRIV_CAPTURE$ SYS_STUB_FOR_PURITY_ANALYSIS
Detects Privilege Capture usage dbms_feature_priv_capture(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_priv_capture(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 1
3:
 
DBMS_FEATURE_QOSM
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS X$KYWMPCTAB  
Detects Oracle Quality of Service Manager usage dbms_feature_qosm(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_qosm(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_RAC
Dependencies
GV$INSTANCE SYS_STUB_FOR_PURITY_ANALYSIS V$SYSTEM_PARAMETER
GV$LICENSE    
Detects whether the database is part of a RAC cluster dbms_feature_rac(
is_used   OUT NUMBER,
nodes     OUT NUMBER,
clob_rest OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rac(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_RAS
Dependencies
DBA_ROLE_PRIVS SYS_STUB_FOR_PURITY_ANALYSIS XS$OBJ
DBA_XS_APPLIED_POLICIES XS$ACE XS$PRIN
DBA_XS_ROLE_GRANTS XS$ACL XS$PRIV
RXS$SESSIONS XS$DSEC XS$SECCLS
Detects Real Application Security User dbms_feature_ras(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_ras(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 0
3: Real Application Security usage not detected
 
DBMS_FEATURE_RESOURCE_MANAGER
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects Resource Manager usage dbms_feature_resource_manager(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_resource_manager(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: CPU Management: 1, Other Management: 0
 
DBMS_FEATURE_RMAN_BACKUP
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects RMAN for backup usage dbms_feature_rman_backup(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rman_backup(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_RMAN_BASIC
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects RMAN BASIC Compression usage dbms_feature_rman_basic(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rman_basic(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_RMAN_BZIP2
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects BZIP2 for Backup Compression usage dbms_feature_rman_bzip2(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rman_bzip2(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_RMAN_DISK_BACKUP
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of RMAN for disk backup dbms_feature_rman_disk_backup(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rman_disk_backup(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_RMAN_HIGH
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of RMAN HIGH compression dbms_feature_rman_high(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rman_high(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_RMAN_LOW
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of RMAN LOW compression dbms_feature_rman_low(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rman_low(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_RMAN_MEDIUM
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of RMAN MEDIUM compression dbms_feature_rman_medium(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rman_medium(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_RMAN_TAPE_BACKUP
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of RMAN for tape backup dbms_feature_rman_tape_backup(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rman_tape_backup(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_RMAN_ZLIB
Dependencies
DBMS_BACKUP_RESTORE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of ZLIB Compression dbms_feature_rman_zlib(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rman_zlib(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_ROND
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS X$KJIDT  
Detect RAC One Node usage dbms_feature_rond(
is_used      OUT NUMBER,
aux_count    OUT NUMBER,
feature_info OUT CLOB;
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rond(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Database is of type SINGLE
 
DBMS_FEATURE_RULESMANAGER
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of Rules Manager and Expression Filters dbms_feature_rulesmanager(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_rulesmanager(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Rules Manager/Expression Filter usage not detected
 
DBMS_FEATURE_SECUREFILES_SYS
Dependencies
LOB$ OBJ$ TAB$
LOBCOMPPART$ PARTLOB$ USER$
LOBFRAG$ SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of Oracle SecureFiles by SYS, SYSTEM, and XDB dbms_feature_securefiles_sys(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_securefiles_sys(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 402
2: 402
3:
 
DBMS_FEATURE_SECUREFILES_USR
Dependencies
LOB$ OBJ$ TAB$
LOBCOMPPART$ PARTLOB$ USER$
LOBFRAG$ SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of Oracle SecureFiles by users other than SYS, SYSTEM, or XDB dbms_feature_securefiles_usr(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_securefiles_usr(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 327
2: 327
3:
 
DBMS_FEATURE_SEGADV_USER
Dependencies
DBA_ADVISOR_EXECUTIONS DBMS_LOB WRI$_ADV_MESSAGE_GROUPS
DBA_ADVISOR_TASKS SYS_STUB_FOR_PURITY_ANALYSIS WRI$_ADV_RECOMMENDATIONS
DBA_FEATURE_USAGE_STATISTICS WRI$_ADV_FINDINGS  
Detects usage of Segment Advisor by tasks not named like 'SYS_AUTO_SPCADV%' dbms_feature_segadv_user(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_segadv_user(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Executions since last sample: 0, Total Executions: 0, Total Recommendations:
0, Projected Space saving (byte): 0
 
DBMS_FEATURE_SEG_MAIN_ONL_COMP
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS TABPART$ TABSUBPART$
Tracks the segments compressed as a result of an online partition maintenance operation like MOVE dbms_feature_seg_main_onl_comp(
isAnyFragCompressed OUT NUMBER,
numFragsCompressed  OUT NUMBER,
fragObjNumList      OUT CLOB)
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_seg_main_onl_comp(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_SEHA
Dependencies
KJHAISSEHA SYS_STUB_FOR_PURITY_ANALYSIS  
Detects use of High Availability options in Standard Edition

If SE then calls kjhaisseha		 dbms_feature_seha(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_seha(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_SERVICES
Dependencies
DBA_SERVICES SYS_STUB_FOR_PURITY_ANALYSIS V$PARAMETER
GV$ACTIVE_SERVICES    
Detects Services Usage dbms_feature_services(
is_used      OUT NUMBER,
hwm          OUT NUMBER,
feature_info OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_services(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 3
3: num_clb_long: 3 num_clb_short: 0 num_goal_service_time: 0 num_goal_throughput: 0 num_goal_none: 3 num_aq_notifications: 0 num_active_services: 2 avg_active_cardinality: 1
 
DBMS_FEATURE_SFCOMPRESS_SYS
Dependencies
LOB$ OBJ$ TAB$
LOBCOMPPART$ PARTLOB$ USER$
LOBFRAG$ SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of SecureFile Compression by SYS, SYSTEM, and XDB dbms_feature_sfcompress_sys(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_sfcompress_sys(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_SFCOMPRESS_USR
Dependencies
LOB$ OBJ$ TAB$
LOBCOMPPART$ PARTLOB$ USER$
LOBFRAG$ SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of SecureFile Compression by a user other than SYS, SYSTEM, and XDB dbms_feature_sfcompress_usr(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_sfcompress_usr(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_SFDEDUP_SYS
Dependencies
LOB$ OBJ$ TAB$
LOBCOMPPART$ PARTLOB$ USER$
LOBFRAG$ SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of SecureFile Deduplication by SYS, SYSTEM, and XDB dbms_feature_sfdedup_sys(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_sfdedup_sys(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_SFDEDUP_USR
Dependencies
LOB$ OBJ$ TAB$
LOBCOMPPART$ PARTLOB$ USER$
LOBFRAG$ SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of SecureFile Deduplication by users other than SYS, SYSTEM, and XDB dbms_feature_sfdedup_usr(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_sfdedup_usr(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_SFENCRYPT_SYS
Dependencies
LOB$ OBJ$ TAB$
LOBCOMPPART$ PARTLOB$ USER$
LOBFRAG$ SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of SecureFile Encryption by SYS, SYSTEM, and XDB dbms_feature_sfencrypt_sys(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_sfencrypt_sys(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_SFENCRYPT_USR
Dependencies
LOB$ OBJ$ TAB$
LOBCOMPPART$ PARTLOB$ USER$
LOBFRAG$ SYS_STUB_FOR_PURITY_ANALYSIS  
Detects use of SecureFile Encryption by other than SYS, SYSTEM, and XDB dbms_feature_sfencrypt_usr(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_sfencrypt_usr(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_SHARD
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects use of database is a database shard dbms_feature_shard(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_shard(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: The database is not a shard
 
DBMS_FEATURE_SPD
Dependencies
DBA_SQL_PLAN_DIRECTIVES DBMS_SPD X$KSPPCV
DBA_SQL_PLAN_DIR_OBJECTS DUAL X$KSPPI
DBMS_LOB SYS_STUB_FOR_PURITY_ANALYSIS  
Detect statistics incremental maintenance usage dbms_feature_spd(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_spd(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 67
2: 21
3: Number of directives with type, DYNAMIC_SAMPLING: 21
Number of Directives with reason, JOIN CARDINALITY MISESTIMATE: 12
Number of Directives with reason, SINGLE TABLE CARDINALITY
MISESTIMATE: 9
Number of Directives with state, USABLE: 21
Number of Directive objects: 54, subobjects: 18
spd_retention_weeks: 53
_sql_plan_directive_mgmt_control: 67
_optimizer_dsdir_usage_control: 0
 
DBMS_FEATURE_SQL_FIREWALL (new 23ai)
Dependencies
DBA_SQL_FIREWALL_ALLOW_LISTS DBA_SQL_FIREWALL_STATUS SYS_STUB_FOR_PURITY_ANALYSIS
DBA_SQL_FIREWALL_CAPTURES DUAL  
SQL Firewall dbms_feature_sql_firewall(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_sql_firewall(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: [{"num_captures":0,"num_active_captures":0,"num_allow_lists":0,
     "num_enabled_blocking_alwlst":0,
     "num_enabled_nonblocking_alwlst":0}]
 
DBMS_FEATURE_STATS_INCREMENTAL
Dependencies
ALL_TAB_STAT_PREFS DBMS_STATS SYS_STUB_FOR_PURITY_ANALYSIS
DBMS_LOB DUAL WRI$_OPTSTAT_SYNOPSIS_HEAD$
Use of incremental statistics collection dbms_feature_stats_incremental(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_stats_incremental(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Incremental global preference on : FALSE, Number of tables with table level incremental maintenance preference turned on: 0, Number of tables with table level incremental maintenance preference turned off: 0, Number of tables that have had statistics gathered in incremental mode: 0
 
DBMS_FEATURE_STREAMS
Dependencies
DBA_APPLY DBA_PROPAGATION SYS_STUB_FOR_PURITY_ANALYSIS
DBA_CAPTURE    
Detects Streams use dbms_feature_streams(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_streams(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: tcap:0 dscap:0 app:0 prop:0
 
DBMS_FEATURE_TEST_PROC_1
Dependencies
None    
Undocumented: Return values are hard coded

I hope someone was paid well for this amazing piece of engineering.		 dbms_feature_test_proc_1(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_test_proc_1(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 12
3:
 
DBMS_FEATURE_TEST_PROC_2
Undocumented: Return values are hard coded

I hope someone was paid well for this amazing piece of engineering.		 dbms_feature_test_proc_2(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_test_proc_2(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 33
3: Extra Feature Information for TEST_PROC_2
 
DBMS_FEATURE_TEST_PROC_3
Dependencies
None    
Does nothing but return the value 101. Contains the following comment: "/* doesn't matter what I do here as long as the values get * returned correctly. */"

I hope someone was paid well for this amazing piece of engineering.		 dbms_feature_test_proc_3(current_value OUT NUMBER);
set serveroutput on

DECLARE
 i NUMBER;
BEGIN
  sys.dbms_feature_test_proc_3(i);
  dbms_output.put_line('1: ' || i);
END;
/
1: 101
 
DBMS_FEATURE_TEST_PROC_4
Dependencies
DBMS_STANDARD    
Intentionally raises an exception.

Contains the following comment: "/* raise an application error to make sure the error is being * handled correctly */ raise_application_error(-20020, 'Error for Test Proc 4 ');"		 dbms_feature_test_proc_4(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_test_proc_4(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
DECLARE
*
ORA-20020: Error for Test Proc 4
ORA-06512: at "SYS.DBMS_FEATURE_TEST_PROC_4", line 11
 
DBMS_FEATURE_TEST_PROC_5
Dependencies
None    
Does nothing but contains the following comment: "/* What happens if values are not set? */"

Next time perhaps they will just "Ask Tom."		 dbms_feature_test_proc_5(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_test_proc_5(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1:
2:
3: TEST PROC 5
 
DBMS_FEATURE_THP
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS V$ASM_ATTRIBUTE  
Detects use of ASM Thin Provisioning dbms_feature_thp(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_thp(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2:
3:
 
DBMS_FEATURE_TSDP
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects Transparent Sensitive Data Protection Policy usage dbms_feature_tsdp(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_tsdp(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Transparent Sensitive Data Protection feature not used
 
DBMS_FEATURE_UNIFIED_AUDIT
Dependencies
AUDIT_NG$ AUD_CONTEXT$ SYS_STUB_FOR_PURITY_ANALYSIS
AUDIT_UNIFIED_POLICIES AUD_POLICY$ V$OPTION
Detects usage of Unified Audit dbms_feature_unified_audit(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_unified_audit(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 1
2: 0
3: Number of Unified Audit policies=7; Number of Enabled Unified Audit
policies=1; Number of Unified Audit policies with condition=0; Number of Unified
Audit policies on DV=0; Number of Unified Audit policies on OLS=0; Number of
Unified Audit policies on XS=4; Number of Unified Audit policies on DATAPUMP=0;
Number of Enabled Unified Audit Contexts=0
 
DBMS_FEATURE_USER_DV (new 23ai)
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
JSON Duality Views dbms_feature_user_dv(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_user_dv(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: JSON Duality View do not exist.
 
DBMS_FEATURE_USER_MVS
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects Materialized View Use dbms_feature_user_mvs(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_user_mvs(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: User MVs do not exist.
 
DBMS_FEATURE_UTILITIES1
Dependencies
DBA_FEATURE_USAGE_STATISTICS KU_UTLUSE SYS_STUB_FOR_PURITY_ANALYSIS
Detects usage of DataPump Export and associated compression and encryption dbms_feature_utilities1(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_utilities1(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Oracle Utility Datapump (Export) invoked: 0 times, compression used: 0 times
(BASIC algorithm used: 0 times, LOW algorithm used: 0 times, MEDIUM algorithm
used: 0 times, HIGH algorithm used: 0 times), encryption used: 0 times (AES128
algorithm used: 0 times, AES192 algorithm used: 0 times, AES256 algorithm used:
0 times, PASSWORD mode used: 0 times, DUAL mode used: 0 times, TRANSPARENT mode
used: 0 times), parallel used: 0 times
 
DBMS_FEATURE_UTILITIES2
Dependencies
DBA_FEATURE_USAGE_STATISTICS KU_UTLUSE SYS_STUB_FOR_PURITY_ANALYSIS
Detects use of DataPump Import and associated compression and encryption dbms_feature_utilities2(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_utilities2(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Oracle Utility Datapump (Import) invoked: 0 times, parallel used: 0 times
 
DBMS_FEATURE_UTILITIES3
Dependencies
DBA_FEATURE_USAGE_STATISTICS KU_UTLUSE SYS_STUB_FOR_PURITY_ANALYSIS
Detects usage of Metadata API and associated compression and encryption dbms_feature_utilities3(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_utilities3(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 6
2: 6
3:
 
DBMS_FEATURE_UTILITIES4
Dependencies
DBA_FEATURE_USAGE_STATISTICS KU_UTLUSE SYS_STUB_FOR_PURITY_ANALYSIS
Detects usage of External Tables and associated compression and encryption dbms_feature_utilities4(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_utilities4(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Oracle Utility External Table invoked: 0 times, compression used: 0 times
(BASIC algorithm used: 0 times, LOW algorithm used: 0 times, MEDIUM algorithm
used: 0 times, HIGH algorithm used: 0 times), encryption used: 0 times
 
DBMS_FEATURE_UTILITIES5
Dependencies
DBA_FEATURE_USAGE_STATISTICS KU_UTLUSE SYS_STUB_FOR_PURITY_ANALYSIS
Detects external tables (ORACLE_LOADER) use dbms_feature_utilities5(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_utilities5(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 41
2: 41
3: Oracle Utility External Table (ORACLE_LOADER) invoked 41 times
 
DBMS_FEATURE_UTILITIES6
Dependencies
DBA_FEATURE_USAGE_STATISTICS KU_UTLUSE SYS_STUB_FOR_PURITY_ANALYSIS
Detects external tables (ORACLE_BIGSQL) use dbms_feature_utilities6(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_utilities6(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Oracle Utility External Table (ORACLE_BIGSQL) invoked 0 times
 
DBMS_FEATURE_VPD
Dependencies
DBA_POLICIES DBA_SEC_RELEVANT_COLS DBMS_UTILITY
DBA_POLICY_ATTRIBUTES DBA_USERS SYS_STUB_FOR_PURITY_ANALYSIS
Counts Virtual Private Database (Row Level Security) usage

Output, at right, formatted for clarity		 dbms_feature_vpd(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_vpd(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: Number of policies=0,
   Number of enabled policies=0,
   Number of objects that have VPD policies=0,
   Number of policies on SELECT statement=0,
   Number of policies on INSERT statement=0,
   Number of policies on UPDATE statement=0,
   Number of policies on DELETE statement=0,
   Number of policies on INDEX statement=0,
   Number of DYNAMIC policies=0,
   Number of STATIC policies=0,
   Number of SHARED_STATIC policies=0,
   Number of CONTEXT_SENSITIVE policies=0,
   Number of SHARED_CONTEXT_SENSITIVE policies=0,
   Number of attribute associated CONTEXT_SENSITIVE policies=0,
   Number of policies with long predicate=0,
   Number of COLUMN LEVEL policies=0,
   Number of COMMON policies=0,
   Number of INHERITED policies=0
 
DBMS_FEATURE_WCR_CAPTURE
Dependencies
DBA_FEATURE_USAGE_STATISTICS DUAL V$DATABASE
DBA_WORKLOAD_CAPTURES SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage for Workload Capture dbms_feature_wcr_capture(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_wcr_capture(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_WCR_REPLAY
Dependencies
DBA_FEATURE_USAGE_STATISTICS DUAL V$DATABASE
DBA_WORKLOAD_REPLAYS SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage for Workload Replay dbms_feature_wcr_replay(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_wcr_replay(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3:
 
DBMS_FEATURE_XDB
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage for XDB dbms_feature_xdb(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_xdb(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: <xdb_feature_usage>SYSTEM</xdb_feature_usage>
 
DBMS_FEATURE_XSTREAM_IN
Dependencies
DBA_APPLY SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of XStreams Input dbms_feature_xstream_in(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_xstream_in(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: app:0
 
DBMS_FEATURE_XSTREAM_OUT
Dependencies
DBA_APPLY DBA_CAPTURE SYS_STUB_FOR_PURITY_ANALYSIS
Detects usage of XStreams Output dbms_feature_xstream_out(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_xstream_out(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: tcap:0 dscap:0 app:0
 
DBMS_FEATURE_XSTREAM_STREAMS
Dependencies
DBA_APPLY DBA_PROPAGATION SYS_STUB_FOR_PURITY_ANALYSIS
DBA_CAPTURE    
Detects XStreams use for services dbms_feature_xstream_streams(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_xstream_streams(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: tcap:0 dscap:0 app:0 prop:0
 
DBMS_FEATURE_ZFS_EHCC
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS    
Detects usage of ZFS Hybrid Columnar Compression dbms_feature_zfs_ehcc(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_zfs_ehcc(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: EHCC on ZFS: 0
 
DBMS_FEATURE_ZFS_STORAGE
Dependencies
KDZSTORAGETYPE SYS_STUB_FOR_PURITY_ANALYSIS  
Detects usage of ZFS Storage dbms_feature_zfs_storage(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_zfs_storage(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: TS on ZFS: 0
 
DBMS_FEATURE_ZMAP
Dependencies
CLST$ SEG$ SYS_STUB_FOR_PURITY_ANALYSIS
CLSTDIMENSION$ SUM$ TAB$
CLSTKEY$ SUMDETAIL$  
Detect usage of Zone maps dbms_feature_zmap(
feature_boolean OUT NUMBER,
num_cells       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_feature_zmap(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 0
3: { "data": ] }
 
DBMS_HWM_PRIM_SHARDS
Dependencies
GSMADMIN_INTERNAL.CLOUD GSMADMIN_INTERNAL.DATABASE SYS_STUB_FOR_PURITY_ANALYSIS
Detects the number of deployed primary shards in the catalog dbms_hwm_prim_shards(current_value OUT NUMBER);
set serveroutput on

DECLARE
 retVal NUMBER;
BEGIN
  sys.dbms_hwm_prim_shards(retVal);
  dbms_output.put_line(TO_CHAR(retVal));
END;
/
0
 
DBMS_HWM_SHARDS
Dependencies
GSMADMIN_INTERNAL.CLOUD GSMADMIN_INTERNAL.DATABASE SYS_STUB_FOR_PURITY_ANALYSIS
Detects the number of deployed shards in the catalog dbms_hwm_shards(current_value OUT NUMBER);
set serveroutput on

DECLARE
 retVal NUMBER;
BEGIN
  sys.dbms_hwm_shards(retVal);
  dbms_output.put_line(TO_CHAR(retVal));
END;
/
0
 
DBMS_PDB_NUM
Dependencies
SYS_STUB_FOR_PURITY_ANALYSIS V$DATABASE V$PDBS
Returns the number of PDBs detected dbms_feature_acfs(
feature_boolean OUT NUMBER,
aux_count       OUT NUMBER,
feature_info    OUT CLOB);
set serveroutput on

DECLARE
 i NUMBER;
 j NUMBER;
 k CLOB;
BEGIN
  sys.dbms_pdb_num(i, j, k);
  dbms_output.put_line('1: ' || i);
  dbms_output.put_line('2: ' || j);
  dbms_output.put_line('3: ' || k);
END;
/
1: 0
2: 6
3:

Related Topics
Active Data Guard
Auditing
AWR
Built-in Functions
Built-in Packages
CARTRIDGE
Compression
DBMS_DATAPUMP
DBMS_DATA_REDACTION
DBMS_FEATURE_USAGE
DBMS_FEATURE_USAGE_REPORT
DBMS_RESOURCE_MANAGER
DBMS_STREAMS_ADMIN
DBMS_WORKLOAD_CAPTURE
DBMS_WORKLOAD_REPLAY
PRVT_ILM
In-Memory Database
SecureFiles
What's New In 21c
What's New In 26ai