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.

Thank you

Received on Fri Feb 20 2009 - 08:49:21 CST

Original text of this message