My Oracle Support Banner

Unrecoverable Changes reported in v$datafile for User tablespace datafiles due to Internal Compression Advisor tables (Doc ID 2233391.1)

Last updated on NOVEMBER 05, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


 Application related tablespace all have Logging attributes set at segment level.
 Database doesnot have  Force logging mode enabled, However there are No nologging operations like Append with Parallel hint,Direct load are done through Application.

 V$datafile shows Unrecoverable_change# and Unrecoverable_time for user tablespace datafiles.

 Object involved has a name starting with CMP example :- CMP4$225  etc

 Where the last two digits indicates the Object id of the for  which this compression table was created



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

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