Compression On Small Tables Increase Elapse Time And CPU Time 50+% More
(Doc ID 2855739.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Two tables (one under 200mb, the other 120mb), no LOBs, not partitioned, were compressed. The queries are executed very frequently against these tables and had a significant increase in elapsed and CPU time. These tables are not updated frequently but have a high volume of SELECTs against them. The queries are not complicated queries.
Tables were compressed.
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