Re: Unit of TIME in dbms_xplan
Date: Sat, 27 Dec 2008 15:17:13 -0800 (PST)
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.
> 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