My Oracle Support Banner

RDBPROD: TRUNCATE TABLE or DROP INDEX May Leave Wasted Space (Doc ID 1154195.1)

Last updated on JANUARY 10, 2018

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2.4.1 to 7.2.4.1 [Release 7.2]
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

When performing a TRUNCATE TABLE or a DROP INDEX on a HASHED INDEX stored in mixed-format area, not all buckets for records are effectively removed.

This may lead to wasted space on a page. New INSERTs may not find enough space on a page and overflow records need to be created, which may lead to declining performance.

Changes

This problem occurs only under Rdb 7.2.4.1, on both Alpha and Itanium

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!


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