We recently decided to export/import our database so it would rebuild the tablespaces and eliminate fragmentation. We also increased the size of some DB files(and tablespaces). Everything seemed to go smooth but then the locks started.
We have been getting several locks on one table during high DB activity -sometimes lasting for 20 - 30 min. This is a 5.5 million row table and seems to be the only spot of trouble. We have examined everything we could think of and are running out of ideas.
Has anyone heard of a similar problem ??
timeouts in - Library Cache pin and Latch free waits
DBWR scan depth is bit high
logical I/O consistent reads are high