Database Tuning (MOSC)

MOSC Banner

latch waits after frequent delete/insert in assm tablespace

edited Jan 8, 2013 11:42AM in Database Tuning (MOSC) 9 commentsAnswered
Recently, I had a process that performs table refreshes via a delete and insert operation take longer to process due to latch waits and a possible hot block problem.  Given the fact that the process performs deletes as opposed to a truncate, I assumed that there could be freelist contention.  The table(s) resides in an ASSM tablespace and since the blocks are managed with multiple bitmaps, the freelist contention did not seem plausible.  However, I truncated the worst offending table and performed a load test again and the processing time returned to normal.  The developer has been running this process

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center