#733. You have been seeing poor performance for inserts into a new table. You queried V$WAITSTAT and V$SYSTEM_EVENT and determined that there is free list contention in your database. Next, you identified the segments by joining the DBA_SEGMENTS table and V$SESSION_WAIT view to identify the file and block where waits are occurring. What is the next step you should take?
gen. 0.09
Forum
Master braindump