check_ac.sql adv compression

[code language=”sql”]   set head off set feedback off set serveroutput on whenever sqlerror exit; set termout on set scan off set linesize 128 declare v_hostname sys.v$instance.host_name%TYPE; v_dbname sys.v$database.db_unique_name%TYPE; v_db_role sys.v$database.database_role%TYPE; ex_custom exception; rowcnt number := 0; v_message varchar2(50); v_installed number := 0; v_used number := 0; v_ac_cnt number := 0; sql_stmt1 varchar2(1000) := ‘WITH […]

HCC Compression

HCC Compression Whitepaper – 2012 Oracle whitepaper HCC Scripts Compression Whitepaper How it Works – 2013 Estimate The Compression

Compression Check Script

Compression Check Script [code language=”sql”] #!/bin/ksh ############################################################################ # Script Name..: comp_chk.ksh # Description..: Estimate the compression for a table # Author…….: Michael Culp # Date………: # Version……: # Modified By..: # Date Modified: # Comments…..: # Schema owner.: # Login User…: # Run Order….: # Dependent on.: # Script type..: # ############################################################################ sqlplus -s "/ […]