I have noticed in the database some blocks, the event was read by other session, I have identified the table and the index causing that. However I have noticed the table statistics are 3 month old where everyday there are DML (insert/update/deletes) and the pct free is 0.
My question is what is the relation between pct free 0 and the Event ? Note that It might the asm change it to 0 as I am not sure how it was changed. the default value is 10.
In any case my solution for this issue:
- updating the statistics.
- increase the pctfree to 10(the defaults value for the other
tables)? - changing the order of the index
- recreating the table will reset the hot blocks.
- moving it to a new tablespace tough it require downtime