Oracle PRVT_COMPRESS
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented support for likely for Advanced and/or Hybrid Columnar Compression
AUTHID DEFINER
Dependencies
DBMS_ASSERT PRVT_COMPRESSION TABSUBPART$
DBMS_COMPRESSION SEG$ V$IM_SEGMENTS_DETAIL
DBMS_INMEMORY_LIB TAB$ V$PARAMETER
PRVT_PARTREC_NOPRIV TABPART$  
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
Undocumented prvt_compress.get_arch_comp(
dobjno  IN NUMBER,
dictobj IN NUMBER,
objtype IN NUMBER)
RETURN BOOLEAN;
conn / as sysdba

CREEATE TABLE comp_all_oper
COMPRESS FOR ALL OPERATIONS AS
SELECT * FROM tab$;

SQL> SELECT o.obj#, o.dataobj#, o.type#
   2 FROM obj$ o
   3 WHERE o.name = 'COMP_ALL_OPER';

      OBJ#   DATAOBJ#      TYPE#
---------- ---------- ----------
     92954      92954          2

BEGIN
  IF prvt_compress.get_arch_comp(92954,92954,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 27
ORA-06512: at line 2
 
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;
/
 
GET_TS_NUM
Undocumented prvt_compress.get_ts_num(
dobjno  IN NUMBER,
dictobj IN VARCHAR2,
objtype IN VARCHAR2)
RETURN NUMBER;
SQL> SELECT DISTINCT obj#, dataobj#, ts#
  2  FROM tabpart$
  3  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

Related Topics
Advanced Compression
Built-in Functions
Built-in Packages
DBMS_COMPRESSION
LOB Compression
PRVT_COMPRESSION
UTL_COMPRESS
What's New In 18cR3
What's New In 19cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx