We have a table with around a billion rows with one Primary Key. Number of
columns in the table are fewer than 10 and all are numbers data type.
Application is doing few million inserts but running very slow. It is Exadata
with two node and 10CPU and good SGA (bufer Cache 10G). Waits are coming
heavily only for "cell single block physical read" for Insert process. While
doing SQL Monitor shows it is doing high IO like more than 100G for simple
Insert. Oracle version is 12.2.
Any suggestions as what can be the reason for this wait event in this scenario.