RE: Simple insert - 36,000 physical reads
Date: Fri, 12 Dec 2008 15:12:10 -0600
Message-ID: <75064C4060A3A24787B52E1F7D3E410C092662F9@DBQV3005.na.corp.mckesson.com>
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams
Sent: Friday, December 12, 2008 3:55 PM
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 12 2008 - 15:12:10 CST