Re: awrsqlrpt

From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 5 Jan 2010 11:58:44 -0800
Message-ID: <a9c093441001051158pee05a42nf234da6f1e9b26fd_at_mail.gmail.com>



The Time column from DBMS_WORKLOAD_REPOSITORY.AWR_SQL_REPORT_HTML and dbms_xplan.display_cursor is an estimation on how long the statement is believed to run based on the CBO costing model. I find it frequently inaccurate so I would probably ignore it for now and try and understand the plans a bit better.

On Tue, Jan 5, 2010 at 6:08 AM, <niall.litchfield_at_gmail.com> wrote:
> but at the moment I'm just trying to understand what the time field is
> trying to tell me.

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 05 2010 - 13:58:44 CST

Original text of this message