Kbase P123316: Type II Storage area - space allocation issue with creates and updates.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/22/2010 |
|
Status: Verified
SYMPTOM(s):
Database engine does not seem to reuse space when creating, deleting or update records in a Type II storage area.
Table resides in a Type II storage area that exhibits the excessive space usage.
Excessive space usage for a table that is in a Type II storage area
prostrct statistics showing physical storage being used by the table as being 100 GB
Dbanalys shows that Average Record size multiplied by Total # of records should occupy only 256 MB of disk space.
Fix for Bug# OE00128403 installed.
FACT(s) (Environment):
Multiple users creating and updating records from one table simultaneously.
128 records per block
512 cluster size
8 KB database block size
Using default create and toss limits for a database block.
OpenEdge 10.x
UNIX
Windows
OpenEdge 10.0x
OpenEdge 10.1A
OpenEdge 10.1B
CAUSE:
Bug# OE00148573
FIX:
Upgrade to 10.1B02 or later.
Workaround:
Perform a tablemove or dump and load into a Type I storage area.