Re: awrsqlrpt

I was sort of hoping it might be an actual historical figure, rather than an historical estimate!

Niall

On Tue, Jan 5, 2010 at 7:58 PM, Greg Rahn <greg_at_structureddata.org> wrote:

> 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
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l