Re: Unit of TIME in dbms_xplan

On Dec 27, 10:25 am, zigzag..._at_yahoo.com wrote:
> I am 10.2.0.3 on HP UNIX 11i
>
> I  use sqlplus to run a query. I set set autotrace on which I think
> calls dbms_xplan to display the sql plan. Query took 54 seconds
> to complete (using UNIX time x command).
>
> Plan (only few lines are shown), times are lot more.   I do not
> understand TIME for each operation. Is it in HH:MI:SS format.  How can
> time of several operations (00:01:58) – 118 seconds be larger than
> total execution time of the query.

It is in HH:MI:SS, but it is not very reliable. Don't get caught up by it. It's just an estimate, but not always a good one.

--
Regards,
Greg Rahn
http://structureddata.org