RE: Simple insert - 36,000 physical reads

From: "Channa, Santhosh" <Santhosh.Channa@xxxxxxxxxxxx>
To: oracledba.williams@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Fri, 12 Dec 2008 15:12:10 -0600

Are the values for the insert are straight values or any home-grown
function calls that generates the values?

 

Regards,
Santhosh Channa



  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dennis Williams
Sent: Friday, December 12, 2008 3:55 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Simple insert - 36,000 physical reads

 

List,

 

Oracle 10.2.0.4 <http://10.2.0.4> , Solaris 8

 

I've found a simple insert that has:

     1 execution

     2,512,102 Buffer Gets

     36,479 Physical Reads

     1 Parse call

     1 Row

 

This insert statement appears quite a few times in the AWR report, and
for the times I see it, the statistics are pretty close to what I've
listed. The insert just has a list of columns and a list of values. No
subqueries. There is a TO_DATE conversion on two columns.This is a real
table, not a view.

 

Does anyone have any suggestions of why a simple insert could cause this
much database activity?

 

Thanks to Brandon for suggesting awrsqrpt.sql in response to another
question. That is a great tool.

 

Dennis Williams

References:
- Simple insert - 36,000 physical reads
  - From: Dennis Williams

RE: Simple insert - 36,000 physical reads

Other related posts: