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

The lecture covers advanced compression techniques in Oracle databases, focusing on the mechanism of data compression when the BCT free limit is reached. It highlights the advantages of advanced compression over basic compression, such as its compatibility with regular insert statements and potential performance gains. Licensing requirements for advanced compression are discussed, along with implementation steps and methods to retrieve compression information. The lecture also introduces Oracle Hybrid Columnar Compression, noting its efficiency and hardware-specific availability. The session concludes with a summary of key points and a brief mention of upcoming practice lectures.

What happens to data in a block when it reaches the BCT free limit?

• It is deleted.

• It is moved to another block.

• It gets compressed.

• It remains unchanged.

Which of the following is a requirement for using advanced compression?

• It is only available for cloud databases.

• It requires a separate license.

• It is included in the basic Oracle license.

• It can be used without any license.

What is a key advantage of advanced compression over basic compression?

• It is faster to implement.

• It provides unlimited storage.

• It works with conventional insert statements.

• It does not require any license.

Which SQL keywords are used to implement advanced compression?

• COMPRESS BASIC

• RAW STORE, COMPRESS ADVANCED

• COMPRESS TABLE

• STORE ADVANCED

How can you check if a table uses advanced compression?

• By running a compression test.

• By using the DBMS_STATS package.

• By checking the database logs.

• By querying the user_tables view.

What is a significant feature of Oracle Hybrid Columnar Compression?

• It provides a 2X compression ratio.

• It is only for text data.

• It is available on all Oracle databases.

• It requires specific hardware.

What is the potential compression ratio offered by Oracle Hybrid Columnar Compression?

• 1X to 3X

• 5X to 15X

• 20X to 30X

• 50X to 100X