Oracle | PRVT_COMPRESS

Oracle PRVT_COMPRESS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented support for likely for Advanced and/or Hybrid Columnar Compression

AUTHID DEFINER

Dependencies

DBMS_ASSERT	SEG$	TABSUBPART$
DBMS_COMPRESSION	TAB$	V$IM_SEGMENTS_DETAIL
DBMS_INMEMORY_LIB	TABPART$	V$PARAMETER
PRVT_COMPRESSION

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

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

Subprograms

GET_ARCH_COMP	GET_TS_NUM	LOAD_TAB_INMEMORY
GET_COMPATIBLE

GET_ARCH_COMP

Undocumented prvt_compress.get_arch_comp( dobjno IN NUMBER, dictobj IN NUMBER, objtype IN NUMBER) RETURN BOOLEAN;

conn / as sysdba

      

      CREATE TABLE comp_all_oper

      COMPRESS FOR ALL OPERATIONS AS

      SELECT * FROM tab$;

      

      SELECT o.obj#, o.dataobj#, o.type#

      FROM obj$ o

      WHERE o.name = 'COMP_ALL_OPER';

      

            OBJ#   DATAOBJ#      TYPE#

      ---------- ---------- ----------

           78810      78810          2

      

      BEGIN

        IF prvt_compress.get_arch_comp(78810,78810,2) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      BEGIN

      *

      ERROR at line 1:

      ORA-01403: no data found

      ORA-06512: at "SYS.PRVT_COMPRESS", line 62

      ORA-06512: at line 2

      

      -- it appears that the TYPE# returned in the above query is the what this function

      -- wants as replacing the "2" with a "1" eliminates the exception

      

      BEGIN

        IF prvt_compress.get_arch_comp(78810,78810,1) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

GET_COMPATIBLE

Undocumented prvt_compress.get_arch_comp(p_first4 OUT NUMBER);

DECLARE

       outVal NUMBER;

      BEGIN

        prvt_compress.get_compatible(outVal);

        dbms_output.put_line(TO_CHAR(outVal));

      END;

      /

      19

GET_TS_NUM

Undocumented prvt_compress.get_ts_num( dobjno IN NUMBER, dictobj IN VARCHAR2, objtype IN VARCHAR2) RETURN NUMBER;

SELECT DISTINCT obj#, dataobj#, ts#

      FROM tabpart$

      WHERE rownum < 6;

      

            OBJ#   DATAOBJ#        TS#

      ---------- ---------- ----------

            6445       6445          1

            6451       6451          1

            6461       6461          1

            7584       7584          0

            7585       7585          0

      

      DECLARE

       retVal NUMBER;

      BEGIN

        retVal := prvt_compress.get_ts_num(6445, 6445, 'PARTITION');

        dbms_output.put_line(TO_CHAR(retVal));

      END;

      /

      DECLARE

      *

      ERROR at line 1:

      ORA-01403: no data found

      ORA-06512: at "SYS.PRVT_COMPRESS", line 81

      ORA-06512: at line 4

LOAD_TAB_INMEMORY

Undcoumented prvt_compress.load_tab_inmemory( safe_tabowner IN VARCHAR2, safe_tabname IN VARCHAR2, objd IN NUMBER, imc_bytes IN NUMBER);

TBD