On 10.09.2007, ebwright_at_gmail.com <ebwright_at_gmail.com> wrote:
> I guess I'm really looking for information on what would cause a large
> elapsed/cpu ratio in general
> rather than help optimizing the specific query.
>
Including wait-events information in the trace file you generated
for the first time would be a great starting point.
Large elapsed/cpu ratio in general means that your session is
waiting for a resource instead of using it and doing its job.
--
Wiktor Moskwa
Received on Mon Sep 10 2007 - 13:45:59 CDT
