Performens - empty blocks, 7.1 Unix

I've got a "small" problem with a 7.1.5 RDBMS version. It seems to have problems reusing totally empty blocks after a rollback or delete. It often occurs after deleting/rollback more than 35000 records.

The symptom is: the rollback/delete completes, and everything seems okay, but subsequent inserts into the table, is about 10-20 times slower than normal (even without any load, processing ONE record in ONE insert takes more than 1 second). This does not happen when the table is FRESH, or if I truncate the table after a rollback, or instead of deleting a lot of rows. All inserts are done from PL/SQL - either directly in a PL/SQL block or via a package. SELECTS also takes forever (Oracle somehow scans all empty blocks??).

Does anyone know of this problem? Is it a 7.1 bug, fixed in 7.2 or is it possible to be a platform specific problem? It seems to me, to be somekind of "freepointer" problem, when PCTUSED gets below default settings ????

Peter H. Larsen             Email: Petlars_at_ibm.net
Complete Data Service       Fidonet: 2:235/134.0

Happy Computing Received on Mon Jun 17 1996 - 00:00:00 CEST