Re: Unit of TIME in dbms_xplan

From: Greg Rahn <>
Date: Sat, 27 Dec 2008 13:17:00 -0800 (PST)
Message-ID: <>

On Dec 27, 10:25 am, wrote:
> I am 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.

Greg Rahn
Received on Sat Dec 27 2008 - 15:17:00 CST

Original text of this message