| General Information |
| Note: This internal package supports advanced compression features in Database 11g version 1 and 2. |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtcmpr.plb |
| First Available |
11.2 |
Dependencies |
| COL$ |
DBMS_OUTPUT |
WRI$_ADV_COMPRESSION_T |
| DBA_OBJECTS_AE |
DBMS_SPACE |
WRI$_ADV_FINDINGS |
| DBMS_ADVISOR |
DBMS_STANDARD |
WRI$_ADV_MESSAGE_GROUPS |
| DBMS_ASSERT |
DUAL |
WRI$_ADV_OBJECTS |
| DBMS_COMPRESSION |
PLITBLM |
WRI$_ADV_SEQ_MSGGROUP |
| DBMS_LOB |
TAB$ |
|
|
| Security Model |
Owned by SYS with no privileges granted |
| |
| 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; |
SELECTprvt_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 |
