Simple Insert - very slow
From: Sanjay Mishra <"Sanjay>
Date: Fri, 17 May 2019 15:47:12 +0000 (UTC)
Message-ID: <1660325206.712436.1558108032380_at_mail.yahoo.com>
Date: Fri, 17 May 2019 15:47:12 +0000 (UTC)
Message-ID: <1660325206.712436.1558108032380_at_mail.yahoo.com>
Hi All
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.
TIASanjay
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 17 2019 - 17:47:12 CEST