Re: buffer busy wait for insert session

Zhu,

Perhaps, would be useful to have a look at what segments and type of blocks are involved (P1&P2).

If your create_date column is a monotonically growing timestamp than chances are that this index is the issue. The option would be to recreate this index as REVERSE KEY and/or use hash partitioning as Gopal noticed.
The same would be for PK if it's on monotonically increasing item_id column= .

--=20
Best regards,
Alex Gorbachev

--
http://www.freelists.org/webpage/oracle-l