First page Back Continue Last page Overview Graphics

Workshop

Table Compression

Notes:

Table Compression Workshop
Run the supplied script TABLE_COMPRESSION_PREP.SQL. This script creates 2 tables, T1 and T2. Both tables are identical except that T2 was created with the COMPRESS option.
Query the data dictionary to view the difference in space used between tables T1 and T2.
SELECT bytes, blocks FROM user_segments
WHERE segment_name = 'T1';
SELECT bytes, blocks FROM user_segments
WHERE segment_name = 'T2';

Execute the following SQL*Plus command to turn on automatic tracing.
SET AUTOTRACE TRACEONLY;