Oracle Database Administration from Zero to Hero - Using Table Compression (Part 1 of 2)

The lecture covers Oracle table compression, focusing on basic and advanced types. Basic compression reduces storage by deduplicating repeated values, effective in bulk-loaded, read-only tables. Direct path loading enhances performance by bypassing buffer cache. Implementation involves setting table attributes, with options for existing tables. The lecture emphasizes scenarios for optimal use and potential CPU overhead.

What is the purpose of the append hint in direct path loading?

What happens to existing rows when the compression attribute of a table is changed?

How can compression be set at the table space level in Oracle?