improve performance of inserts on IOT
Hello Everyone,
Here is the issue:
The DB has one table, IOT type and range partitioned by hour.
The insert rate is 50000 rows per second on average.
The DB is configured with Dataguard and has a physical standby in ASYNC mode.
The DB also has flashback enabled.
The problem is that when the partition switches to a new one every hour, we are experiencing insert latencies that can last for 5 mins, due to which customers are affected.
The waits are mostly "db file sequential reads". Below is a 10 minutes awr snapshot taken on top of the hour.
Event Waits Time(s) (ms) time Wait Class
Here is the issue:
The DB has one table, IOT type and range partitioned by hour.
The insert rate is 50000 rows per second on average.
The DB is configured with Dataguard and has a physical standby in ASYNC mode.
The DB also has flashback enabled.
The problem is that when the partition switches to a new one every hour, we are experiencing insert latencies that can last for 5 mins, due to which customers are affected.
The waits are mostly "db file sequential reads". Below is a 10 minutes awr snapshot taken on top of the hour.
Event Waits Time(s) (ms) time Wait Class
0