My Oracle Support Banner

Table Compression Count Statistic (Doc ID 1357738.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Goal


=== ODM Question ===

  We are in process of testing table compression feature with: compress for all operations, however we are trying to determine:

1. Why so much undo is being generated, we believe this is due to the before image of the block being retained in undo segment every time compression is applied to the block?

 Initially we ran few test which indicated, column: v$transaction.used_ublk (undo block) and statistic: heap block compress increased every time compression occurred.

2. What is the correct session level statistic that verifies "how many" times compression took place?

3. What is the difference between: HSC OLTP positive compress and heap block compress?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Goal
  Solution
  References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.