Elapsed Time for a DML Statement
From: FMHabash <fmhabash_at_gmail.com>
Date: Fri, 20 Feb 2009 09:49:21 -0500
Message-ID: <499ec2ef.0c17400a.3f2f.ffffb8f5_at_mx.google.com>
I have run into an issue lately where an application witnessed degredation affecting only 'insert' statements following an app upgrade. We saw that ET did not change before or after the upgrade. However, in awr, we saw 'redo write time' has gone up 30%. This observation is suggesting a DML ET does not include commit or redo time. Can someone confirm or refute this argument please.
Date: Fri, 20 Feb 2009 09:49:21 -0500
Message-ID: <499ec2ef.0c17400a.3f2f.ffffb8f5_at_mx.google.com>
I have run into an issue lately where an application witnessed degredation affecting only 'insert' statements following an app upgrade. We saw that ET did not change before or after the upgrade. However, in awr, we saw 'redo write time' has gone up 30%. This observation is suggesting a DML ET does not include commit or redo time. Can someone confirm or refute this argument please.
Thank you
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 20 2009 - 08:49:21 CST