DSSIZE value for PERM_IN_USE_SIZE may not be accurate, too high, in certain circumstances (Doc ID 1552106.1)

Last updated on SEPTEMBER 23, 2016

Applies to:

TimesTen Data Server - Version 11.2.1.9.2 and later
Information in this document applies to any platform.

Symptoms

After a large DELETE was performed on a table containing out of line columns  the value for PERM_IN_USE_SIZE in DSSIZE did not appear to take into account all the space freed up.

A ttcompact did help but again did not recover all reclaimable space.

The only way to reclaim this space was to use ttmigrate.

However this space was utilized over time with new data using it. There was no underlying unaccountable space but DSSIZE did not give a true indication of used space at face value.

Changes

 A large DELETE was performed.

Cause

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 hundreds of Community platforms