Oracle | DBMS_SECUREFILES

Oracle DBMS_SECUREFILES 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 Outputs metadata for SecureFile compression and deduplication ratios.

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
Deduplication
DEDUP_RATIO_ALLROWS	NUMBER	-1
DEDUP_RATIO_LOB_MINROWS	NUMBER	1000
DEDUP_RATIO_LOB_MAXROWS	NUMBER	100000
Compression
COMPRESS_RATIO_ALLROWS	NUMBER	-1
COMPRESS_RATIO_LOB_MINROWS	NUMBER	1000
COMPRESS_RATIO_LOB_MAXROWS	NUMBER	100000

Dependencies

ALL_LOBS	DBMS_CRYPTO
ALL_OBJECTS	DBMS_INTERNAL_LOGSTDBY
ALL_TAB_COLUMNS	DBMS_OUTPUT
ALL_TAB_PARTITIONS	DBMS_SECUREFILES_HELPER
ALL_TAB_SUBPARTITIONS	DBMS_STANDARD
ALLL_VARRAYS	PRVT_COMPRESSION
DBMS_ASSERT

Documented Yes

First Available 26ai

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmssecurefiles.sql
{ORACLE_HOME}/rdbms/admin/prvtsecurefiles.plb

Subprograms

GET_LOB_COMPR_RATIO

GET_LOB_DEDUPLICATION_RATIO

GET_LOB_COMPR_RATIO (new 26ai)

Estimates the potential storage savings by enabling compression on SecureFile LOBs dbms_securefiles.get_lob_compr_ratio( tablespacename IN VARCHAR2, tabowner IN VARCHAR2, tabname IN VARCHAR2, lobcolumnname IN VARCHAR2, partname IN VARCHAR2, comp_ratio OUT NUMBER, subset_numrows IN NUMBER, block_compr_ration OUT NUMBER, total_time OUT NUMBER, comptype IN NUMBER, blkcnt_uncmp OUT BINARY_INTEGER, blkcnt_cmp OUT BINARY_INTEGER, lobcnt OUT BINARY_INTEGER) RETURN NUMBER;

TBD

GET_LOB_DEDUPLICATION_RATIO (new 26ai)

Estimates the potential storage savings by enabling deduplication on SecureFile LOBs dbms_securefiles.get_lob_deduplication_ratio( tablespacename IN VARCHAR2, tabowner IN VARCHAR2, tabname IN VARCHAR2, lobcolumnname IN VARCHAR2, partname IN VARCHAR2, dedup_ratio OUT NUMBER, subset_numrows IN NUMBER);

TBD