Re: Unit of TIME in dbms_xplan

On Dec 27, 5:02 pm, Greg Rahn <g..._at_structureddata.org> wrote:
> On Dec 27, 1:20 pm, zigzag..._at_yahoo.com wrote:
>
> > dbms_xplan apperas to generate estimated time and not actual  time, so
> > I am rephrasing my question. Is there a way to ge actaul time for
> > each  operation after statement has been executed.
>
> Yes.  One option is to use the gather_plan_statistics hint followed by
> dbms_xplan.display_cursor with format=>'ALLSTATS LAST'
> Demonstrated here:http://structureddata.org/2007/11/21/troubleshooting-bad-execution-pl...
>
> If you are wanting to go "back in time" and find this info, it's not
> really available until 11g with real-time SQL monitoring.
>
> --
> Regards,
> Greg Rahnhttp://structureddata.org

Thanks a lot, that gives me information I am looking for, Received on Sat Dec 27 2008 - 17:17:13 CST