Deleting many rasters and mosaic very slow and many times fail

Discussion created by modybsystematics-co-il-esridist Employee on Oct 23, 2013
Latest reply on Oct 24, 2013 by mousaem
We are trying to delete about 500 objects for ArcSDE. Some of them are raster datasets and others are Mosaic dataset.
Each delete takes at least 10 minutes and many time fail with a lock message.
Nobody is displaying these rasters and we restart the service so the lock tables were cleaned.
We check the lock tables (TABLE_LOCKS) and found no lock records for any of the rasters.
Checking the SQL that is running in the database we found that the table GDB_TABELS_LAST_MODIFIED is frequently accessed and sometime takes a very long time to return an answer.
The table is very short but the count on the GDB_ITEMS record is millions.
We are using ArcSDE 10.0 on Oracle11g on Linux Red Hat.
We tried to delete with right click on the catalog and select delete or with GP tool (manually and in Python) �?? the results are the same.

Any ideas?