Re: Unit of TIME in dbms_xplan
Date: Sat, 27 Dec 2008 14:02:18 -0800 (PST)
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'
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 Rahn http://structureddata.orgReceived on Sat Dec 27 2008 - 16:02:18 CST