Re: Unit of TIME in dbms_xplan

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 27 Dec 2008 22:35:58 +0100
Message-ID: <49569fc1$0$9077$>

<> a écrit dans le message de news: On Dec 27, 1:25 pm, 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.

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.

Execute it with trace or query v$sql_plan

Michel Received on Sat Dec 27 2008 - 15:35:58 CST

Original text of this message