Oracle PRVT_COMPRESSION Demos

Oracle PRVT_COMPRESSION Version 11.2.0.3

General Information

Purpose

This internal package supports advanced compression features in Database 11g version 1 and 2.

AUTHID

CURRENT_USER

Dependencies

ALL_EXTERNAL_TABLES	DBMS_ADVISOR	PLITBLM
ALL_OBJECTS	DBMS_ASSERT	USER_TABLESPACES
ALL_TABLES	DBMS_COMPRESSION	WRI$_ADV_COMPRESSION_T
ALL_TAB_COLS	DBMS_LOB	WRI$_ADV_FINDINGS
ALL_TAB_PARTITIONS	DBMS_OUTPUT	WRI$_ADV_MESSAGE_GROUPS
ALL_TAB_SUBPARTITIONS	DBMS_SPACE	WRI$_ADV_OBJECTS
DBA_OBJECTS	DUAL	WRI$_ADV_SEQ_MSGGROUP

First Available

11.2.0.1

Security Model

Owned by SYS with EXECUTE granted to PUBLIC

Source

{ORACLE_HOME}/rdbms/admin/prvtcmpr.plb

Subprograms

ADV_ANALYZE_TABLE	GET_NUM_PARTITIONS	OLTP_COMPRESSIBLE
GET_COMPRESSION_RATIO	INIT_TASK_STATE	REPORT

ADV_ANALYZE_TABLE

Undocumented

prvt_compression.adv_analyze_table(
tabowner       IN VARCHAR2,
tabname        IN VARCHAR2,
tabpart        IN VARCHAR2,
comptype       IN NUMBER,
scratchtbsname IN VARCHAR2);

set serveroutput on

exec prvt_compression_adv_analyze_table('UWCLASS', 'SERVERS', NULL, 1, 'UWDATA');

PLS-00114: identifier 'PRVT_COMPRESSION_ADV_ANALYZE_T' too long

GET_COMPRESSION_RATIO

Undocumented

prvt_compression.get_comression_ratio(
scratchtbsname IN VARCHAR2,
tabowner       IN VARCHAR2,
tabname        IN VARCHAR2,
tabpart        IN VARCHAR2,
comptype       IN NUMBER,
blkcnt_cmp     OUT BINARY_INTEGER,
blkcnt_uncmp   OUT BINARY_INTEGER,
row_cmp        OUT BINARY_INTEGER,
row_uncmp      OUT BINARY_INTEGER,
cmp_ratio      OUT NUMBER,
comptype_str   OUT VARCHAR2);

TBD

GET_NUM_PARTITIONS

Returns the number of partitions in a table: 1 for a non-partitioned table

prvt_compression.get_num_partitions(
tabowner IN VARCHAR2,
tabname IN VARCHAR2)
RETURN NUMBER;

SELECT prvt_compression.get_num_partitions('UWCLASS', 'SERVERS')
FROM dual;

INIT_TASK_STATE

Undocumented

prvt_compression.init_task_state(task_id IN NUMBER, fin_id IN NUMBER);

TBD

OLTP_COMPRESSIBLE

Returns TRUE if a table is compressible, otherwise FALSE

prvt_compression.oltp_compressible(
p_owner IN VARCHAR2,
p_table_name IN VARCHAR2)
RETURN BOOLEAN;

set serveroutput on

BEGIN
IF prvt_compression.oltp_compressible('UWCLASS', 'SERVERS') THEN
dbms_output.put_line('TRUE');
ELSE
dbms_output.put_line('FALSE');
END IF;
END;
/

REPORT

Undocumented

prvt_compression.report(
taskid IN NUMBER,
type IN VARCHAR2,
level IN VARCHAR2)
RETURN CLOB;

TBD