My Oracle Support Banner

ASSM Free Block Not Reused After Applying Patch 20466322 (Doc ID 2491771.1)

Last updated on JULY 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

After applying patch 20466322 (or DBPSU which contains patch 20466322), blocks can not be reused (eg, 1GB space occupied while it only need 30MB). 
Problem can be reproduced in-house at will by below steps:

1. Apply patch 20466322
2. Create a big table with 1 million rows with CTAS.
3. Delete all the rows and then insert all the rows again with "INSERT INTO TEST_INSERT SELECT * FROM", then commit and check the table size.
4. Repeat delete/insert/commit 20 times, and table size is increased from 192MB to around 750MB (more FS4 blocks are seen)

Changes

 

Cause

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
Changes
Cause
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.