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 is now availble. If you haven't you downloaded already: Why?

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