Re: Unit of TIME in dbms_xplan

From: Greg Rahn <>
Date: Sat, 27 Dec 2008 14:02:18 -0800 (PST)
Message-ID: <>

On Dec 27, 1:20 pm, 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:

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 Rahn
Received on Sat Dec 27 2008 - 16:02:18 CST

Original text of this message