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

Other related posts: