Temp

From Oramosswiki

SET SERVEROUTPUT ON SIZE UNLIMITED
DECLARE
  l_blkcnt_cmp PLS_INTEGER;
  l_blkcnt_uncmp PLS_INTEGER;
  l_row_cmp PLS_INTEGER;
  l_row_uncmp PLS_INTEGER;
  l_cmp_ratio PLS_INTEGER;
  l_comptype_str VARCHAR2(2000);
BEGIN
  dbms_compression.get_compression_ratio(scratchtbsname => 'STRMADMIN_SCHEMA'
                                        ,ownname => 'J4134'
                                        ,tabname => 'J4134_TABLES'
                                        ,partname => NULL
                                        ,comptype => 2
                                        ,blkcnt_cmp => l_blkcnt_cmp
                                        ,blkcnt_uncmp => l_blkcnt_uncmp
                                        ,row_cmp => l_row_cmp
                                        ,row_uncmp => l_row_uncmp
                                        ,cmp_ratio => l_cmp_ratio
                                        ,comptype_str => l_comptype_str
                                        );
  dbms_output.put_line('blkcnt_cmp: '||TO_CHAR(l_blkcnt_cmp));
  dbms_output.put_line('blkcnt_uncmp: '||TO_CHAR(l_blkcnt_uncmp));
  dbms_output.put_line('row_cmp: '||TO_CHAR(l_row_cmp));
  dbms_output.put_line('row_uncmp: '||TO_CHAR(l_row_uncmp));
  dbms_output.put_line('cmp_ratio: '||TO_CHAR(l_cmp_ratio));
  dbms_output.put_line('comptype_str: '||TO_CHAR(l_comptype_str));

END;
/