EM 13cR3: How To Remove Advanced Compression For OEM Repository (Doc ID 2646519.1)

Last updated on DECEMBER 16, 2020

Applies to:

Enterprise Manager Base Platform - Version 13.3.0.0.0 and later
Information in this document applies to any platform.

In Enterprise Manager (EM) Cloud Control, By default OEM Repository uses the Advanced Compression enabled on table EM_JOB_FINISHED_EXECS_E.

To find Advance Compression is enabled on a table, Kindly run the below query on repository database.

SQL> select owner, table_name, COMPRESSION,compress_for, num_rows from dba_tables where COMPRESSION='ENABLED' and COMPRESS_FOR='ADVANCED';

	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

Symptoms

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