Plan hash value: 1241875880

------------------------------------------------------------------------------------------------------------
| Id  | Operation                 | Name                   | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT          |                        |       |       |       |  1544K(100)|          |
|   1 |  HASH GROUP BY            |                        |   538 | 41426 |       |  1544K  (1)| 05:08:50 |
|*  2 |   HASH JOIN               |                        |    10M|   767M|       |  1543K  (1)| 05:08:46 |
|   3 |    TABLE ACCESS FULL      | DM_TYPE_S              |   538 | 18830 |       |     6   (0)| 00:00:01 |
|*  4 |    HASH JOIN              |                        |  4622K|   185M|   127M|  1543K  (1)| 05:08:45 |
|   5 |     VIEW                  |                        |  4622K|    74M|       | 36403   (1)| 00:07:17 |
|   6 |      HASH GROUP BY        |                        |  4622K|    74M|   152M| 36403   (1)| 00:07:17 |
|*  7 |       INDEX FAST FULL SCAN| X_ATTACH_STRUCT_PARENT |  6631K|   107M|       |  7008   (1)| 00:01:25 |
|   8 |     TABLE ACCESS FULL     | DMI_OBJECT_TYPE        |   519M|    12G|       |   588K  (1)| 01:57:40 |
------------------------------------------------------------------------------------------------------------