Re: Unit of TIME in dbms_xplan

<zigzagdna_at_yahoo.com> a écrit dans le message de news: 4f1e4cd5-7077-4f0d-b33e-f5cbd45013d2_at_e24g2000vbe.googlegroups.com... On Dec 27, 1:25 pm, 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.
>

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

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