Re: Unit of TIME in dbms_xplan
From: Greg Rahn <greg_at_structureddata.org>
Date: Sat, 27 Dec 2008 14:02:18 -0800 (PST)
Message-ID: <f8acbf8d-9bda-45e1-9633-6b2d47cf1092@33g2000yqm.googlegroups.com>
Date: Sat, 27 Dec 2008 14:02:18 -0800 (PST)
Message-ID: <f8acbf8d-9bda-45e1-9633-6b2d47cf1092@33g2000yqm.googlegroups.com>
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-plans/
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