Oracle 18cR3 DBMS_CRYPTO

Oracle DBMS_CRYPTO_INTERNAL Version 18.3.0.1

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

Purpose Undocumented

AUTHID DEFINER

Dependencies

ALL_APPLY_CONFLICT_COLUMNS	DBA_TAB_COLS_V$	KU$_TAB_ONLY_STATS_VIEW
ALL_APPLY_KEY_COLUMNS	DBA_TAB_COLUMNS	SQT_TAB_COL_STATISTICS
ALL_APPLY_TABLE_COLUMNS	DBA_TAB_COL_STATISTICS	USER_COL_PENDING_STATS
ALL_COL_PENDING_STATS	DBA_TAB_HISTGRM_PENDING_STATS	USER_NESTED_TABLE_COLS
ALL_NESTED_TABLE_COLS	DBA_TAB_HISTOGRAMS	USER_PART_COL_STATISTICS
ALL_PART_COL_STATISTICS	DBA_TSTZ_TABLES	USER_PART_HISTOGRAMS
ALL_PART_HISTOGRAMS	DBA_TSTZ_TAB_COLS	USER_SUBPART_COL_STATISTICS
ALL_SUBPART_COL_STATISTICS	EXU10ASC	USER_SUBPART_HISTOGRAMS
ALL_SUBPART_HISTOGRAMS	EXU10ASCU	USER_TAB_COLS
ALL_TAB_COLS	EXU8ASC	USER_TAB_COLS_V$
ALL_TAB_COLS_V$	EXU8ASCU	USER_TAB_COLUMNS
ALL_TAB_COLUMNS	EXU8HST	USER_TAB_COL_STATISTICS
ALL_TAB_COL_STATISTICS	EXU8HSTU	USER_TAB_HISTGRM_PENDING_STATS
ALL_TAB_HISTGRM_PENDING_STATS	KU$_10_1_HISTGRM_MAX_VIEW	USER_TAB_HISTOGRAMS
ALL_TAB_HISTOGRAMS	KU$_10_1_HISTGRM_MIN_VIEW	USER_TSTZ_TABLES
CRYPTO_INTERNAL_LIB	KU$_10_1_PTAB_COL_STATS_VIEW	USER_TSTZ_TAB_COLS
DBA_COL_PENDING_STATS	KU$_10_1_PTAB_STATS_VIEW	WM$COLUMN_PROPS
DBA_LOGSTDBY_EDS_SUPPORTED	KU$_10_1_TAB_COL_STATS_VIEW	WM$DBA_TAB_COLS
DBA_NESTED_TABLE_COLS	KU$_10_1_TAB_ONLY_STATS_VIEW	WM_COMPRESS_BATCH_SIZES
DBA_PART_COL_STATISTICS	KU$_10_1_TAB_STATS_VIEW	_HISTGRM_DEC
DBA_PART_HISTOGRAMS	KU$_10_2_TAB_STATS_VIEW	_HIST_HEAD_DEC
DBA_SUBPART_COL_STATISTICS	KU$_11_2_TAB_STATS_VIEW	_OPTSTAT_HISTGRM_HISTORY_DEC
DBA_SUBPART_HISTOGRAMS	KU$_COL_STATS_VIEW	_OPTSTAT_HISTHEAD_HISTORY_DEC
DBA_TAB_COLS	KU$_HISTGRM_VIEW	_user_stat
	KU$_PTAB_STATS_VIEW	_user_stat_varray

Documented No

First Available 12.2.0.1

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvtcia.plb

Subprograms

STATSDECRYPTNUM	STATSENCRYPTNUM	UPDATESENSITIVESTATS
STATSDECRYPTRAW	STATSENCRYPTRAW

STATSDECRYPTNUM

Undocumented dbms_crypto_internal.statsDecryptNum( obj_nbr IN NUMBER, col_nbr IN NUMBER, encrypted_num IN NUMBER) RETURN NUMBER;

DECLARE

       objNum        sys.wri$_optstat_histhead_history.obj#%TYPE := 8476;

       intCol        sys.wri$_optstat_histhead_history.intcol#%TYPE := 1;

       encryptMinVal sys.wri$_optstat_histhead_history.minimum_enc := 2199;

      BEGIN

        dbms_crypto_internal.statsDecryptNum(obj#, intcol#, minimum_enc);

      END;

      /

STATSDECRYPTRAW

Undocumented dbms_crypto_internal.statsDecryptRaw( obj_nbr IN NUMBER, col_nbr IN NUMBER, ciphertext IN RAW) RETURN RAW;

exec dbms_crypto_internal.statsDecryptRaw( obj#, intcol#, lowval);

STATSENCRYPTNUM

Undocumented dbms_crypto_internal.statsEncryptNum( obj_nbr IN NUMBER, col_nbr IN NUMBER, num_in_clear IN NUMBER) RETURN RAW;

TBD

STATSENCRYPTRAW

Undocumented dbms_crypto_internal.statsEncryptRaw( obj_nbr IN NUMBER, col_nbr IN NUMBER, cleartext IN RAW) RETURN RAW;

TBD

UPDATESENSITIVESTATS

Undocumented dbms_crypto_internal.updateSensitiveStats;

exec dbms_crypto_internal.updateSensitiveStats;