Re: awrsqlrpt
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Jan 2010 21:37:52 +0000
Cheers Greg,
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@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx> 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
Other related posts: