Re: Insert into values generating a lot of logical I/O

From: Dragutin Jastrebic <orahawk_at_gmail.com>
Date: Wed, 30 Oct 2013 18:38:00 +0100
Message-ID: <CANGCQwnHeeYQ5z=hYe9RCpmcZYYQADGsaKHBr0fN8EyfZNpHNA_at_mail.gmail.com>

"

Which has been executed 9,556 times generating more than *50 millions* of Buffers Gets.
*Questions* : How a simple insert into values could generate such a high number of logical I/O."

So you have 5232 buffer gets per simple insert.

Before investigating it further, I would verify that there is no database trigger on the table

" Table_IN "

Dragutin

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 30 2013 - 18:38:00 CET