My Oracle Support Banner

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

Last updated on APRIL 17, 2023

Applies to:

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


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)




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.