Unit of TIME in dbms_xplan
Date: Sat, 27 Dec 2008 10:25:30 -0800 (PST)
Message-ID: <ca60904a-9133-4ef6-be6d-d0f6b17d2319@p29g2000vbn.googlegroups.com>
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.
Plan hash value: 2411281882
| Id | Operation | Name
| Rows |
Bytes |TempSpc| Cost (%CPU)| Time |
| 0 | SELECT STATEMENT |
| 74646 |
9622K| | 9751 (2)| 00:01:58 |
| 1 | SORT ORDER BY |
| 74646 |
9622K| 20M| 9751 (2)| 00:01:58 |
| 2 | HASH UNIQUE |
| 74646 |
9622K| 20M| 7543 (2)| 00:01:31 |
| 3 | NESTED LOOPS |
| 74646 |
9622K| | 5335 (2)| 00:01:05 |
| 4 | NESTED LOOPS |
| 212K|
23M| | 5318 (2)| 00:01:04 |
|* 5 | HASH JOIN |
| 212K|
19M| 4688K| 5301 (2)| 00:01:04 | Received on Sat Dec 27 2008 - 12:25:30 CST