说明:
记得2017年看过一个离谱的Oracle数据库的SQL执行计划,至今仍记忆犹新。
相关数据已脱敏:
问题现象:
同事反馈前台某个功能点击查询很长时间不出结果,咨询是否是数据库的问题;
问题分析:
通过vsession,vsession,vsession,vsql等关联查询到如下SQL运行缓慢,运行时长以及条件等和同事描述一致:
select /*+ 120 query */ * from TEMQ_3558355815e2ce625b9 where rownum<36661 and 1 = 1
其中TEMQ_3558355815e2ce625b9为程序运行过程中自动创建的临时视图,基表关联多张大表。
通过sql_id查看SQL执行计划,看着长长的执行计划,陷入了沉思:
先截取执行计划部分信息:
7-------------------------------------------------------------------------------------------------------------------------------------------------
8| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
9-------------------------------------------------------------------------------------------------------------------------------------------------
10| 0 | SELECT STATEMENT | | | | | 2971M(100)| |
11|* 1 | COUNT STOPKEY | | | | | | |
12| 2 | VIEW | TEMQ_3558355815E2CE625B9 | 5166G| 1837T| | 2971M (98)|999:59:59 |
13|* 3 | SORT GROUP BY STOPKEY | | 5166G| 10P| | 2971M (98)|999:59:59 |
14| 4 | VIEW | | 5166G| 10P| | 105M (35)|352:30:27 |
15| 5 | UNION-ALL | | | | | | |
16|* 6 | FILTER | | | | | | |
17|* 7 | HASH JOIN RIGHT OUTER | | 5166G| 11P| 99M| 30002 (2)| 00:06:01 |
其中: Rows=5166G,Bytes=1837T,Bytes=10P?
看着这些执行计划中少见的单位GB,TB,PB?
如果服务器能开口说话,可能会说:“兄弟,哥何德何能能配得上您这个执行计划呀?”
解决方案:
差不多是从这个SQL执行计划开始,新增了我另一个解决问题的思路:
当你发现你的问题很难解决时,不妨试试能否解决掉提出问题的人!
之前遇到类似的问题,处理过程大概是这样的:
问清楚问题现象,分析原因,找到解决方案,执行方案,解决问题。
但是通过SQL执行计划来看,在不需要其他人员配合的情况下,优化这条SQL,显示是有一定难度的,至少表的数据量太大,关联数量也太多。
做数据库运维时,不能总是被动的接收问题,还要适当的提出问题:
1.这条慢SQL是什么操作触发的?
2.这个操作是否合理?查询条件、范围是否合适?
3.因为你的这个操作已经导致整个数据库性能出现严重问题,能否先中断查询,释放资源,对业务是否有影响,等评估完执行必要性、查询范围、资源消耗等再考虑是否执行,什么时间执行?
得到的答复是:
在临时出一个统计报表,为了图省事没怎么加限制条件,可以中断查询,这个报表不是必须执行的,只是好奇想看一下数据,以后不会再执行类似查询了。
最终的解决方案:
1.中断正在运行的这条慢SQL,释放资源;
2.和相关同事沟通,限制报表查询的数据量,不重要的报表类查询时间超过一定阈值自动中断。
最后看下完整的执行计划:
1SQL_ID 7sf2b262cdhj7, child number 0
2-------------------------------------
3select /*+ 120 query */ * from TEMQ_3558355815e2ce625b9 where rownum<30001 and 1 = 1
4
5Plan hash value: 3569079297
6
7-------------------------------------------------------------------------------------------------------------------------------------------------
8| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
9-------------------------------------------------------------------------------------------------------------------------------------------------
10| 0 | SELECT STATEMENT | | | | | 2971M(100)| |
11|* 1 | COUNT STOPKEY | | | | | | |
12| 2 | VIEW | TEMQ_3558355815E2CE625B9 | 5166G| 1837T| | 2971M (98)|999:59:59 |
13|* 3 | SORT GROUP BY STOPKEY | | 5166G| 10P| | 2971M (98)|999:59:59 |
14| 4 | VIEW | | 5166G| 10P| | 105M (35)|352:30:27 |
15| 5 | UNION-ALL | | | | | | |
16|* 6 | FILTER | | | | | | |
17|* 7 | HASH JOIN RIGHT OUTER | | 5166G| 11P| 99M| 30002 (2)| 00:06:01 |
18| 8 | VIEW | | 615K| 92M| | 24996 (2)| 00:05:00 |
19| 9 | HASH GROUP BY | | 615K| 70M| 152M| 24996 (2)| 00:05:00 |
20|* 10 | HASH JOIN | | 615K| 70M| | 8274 (3)| 00:01:40 |
21|* 11 | HASH JOIN | | 7988 | 733K| | 139 (6)| 00:00:02 |
22|* 12 | TABLE ACCESS FULL | BD_CUBASDOC | 6364 | 285K| | 53 (8)| 00:00:01 |
23|* 13 | TABLE ACCESS FULL | GT_YFINVOICE_H | 7889 | 369K| | 86 (4)| 00:00:02 |
24| 14 | TABLE ACCESS FULL | GT_YFINVOICE_B | 614K| 15M| | 8116 (3)| 00:01:38 |
25| 15 | VIEW | | 311 | 370K| | 1 (0)| 00:00:01 |
26| 16 | UNION-ALL | | | | | | |
27|* 17 | HASH JOIN RIGHT OUTER | | 53G| 59T| | 52M (34)|173:33:50 |
28| 18 | VIEW | | 1221 | 162K| | 1456 (1)| 00:00:18 |
29| 19 | HASH GROUP BY | | 1221 | 225K| | 1456 (1)| 00:00:18 |
30| 20 | NESTED LOOPS | | 1221 | 225K| | 1454 (1)| 00:00:18 |
31| 21 | NESTED LOOPS | | 1221 | 195K| | 475 (2)| 00:00:06 |
32| 22 | NESTED LOOPS | | 127 | 15113 | | 271 (3)| 00:00:04 |
33|* 23 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10287 | | 220 (3)| 00:00:03 |
34| 24 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
35|* 25 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
36|* 26 | TABLE ACCESS BY INDEX ROWID | PO_INVOICE_B | 10 | 450 | | 2 (0)| 00:00:01 |
37|* 27 | INDEX RANGE SCAN | I_PO_INVOICE_B_5 | 14 | | | 1 (0)| 00:00:01 |
38| 28 | TABLE ACCESS BY INDEX ROWID | PO_ORDER_B | 1 | 25 | | 1 (0)| 00:00:01 |
39|* 29 | INDEX UNIQUE SCAN | PK_PO_ORDER_B | 1 | | | 1 (0)| 00:00:01 |
40| 30 | VIEW | | 53G| 52T| | 50M (32)|168:21:50 |
41| 31 | UNION-ALL | | | | | | |
42|* 32 | HASH JOIN RIGHT OUTER | | 53G| 52T| | 25M (32)| 84:13:20 |
43| 33 | VIEW | | 203 | 58058 | | 9 (12)| 00:00:01 |
44| 34 | HASH GROUP BY | | 203 | 10759 | | 9 (12)| 00:00:01 |
45|* 35 | TABLE ACCESS FULL | GT_QCYE | 203 | 10759 | | 8 (0)| 00:00:01 |
46| 36 | VIEW | | 52G| 38T| | 23M (27)| 79:01:37 |
47| 37 | UNION-ALL | | | | | | |
48|* 38 | HASH JOIN RIGHT OUTER | | 52G| 38T| | 11M (27)| 39:30:54 |
49| 39 | VIEW | | 1221 | 162K| | 770 (4)| 00:00:10 |
50| 40 | HASH GROUP BY | | 1221 | 225K| | 770 (4)| 00:00:10 |
51|* 41 | HASH JOIN | | 1221 | 225K| | 769 (4)| 00:00:10 |
52|* 42 | TABLE ACCESS BY INDEX ROWID | PO_INVOICE_B | 10 | 460 | | 2 (0)| 00:00:01 |
53| 43 | NESTED LOOPS | | 1221 | 200K| | 475 (2)| 00:00:06 |
54| 44 | NESTED LOOPS | | 127 | 15494 | | 271 (3)| 00:00:04 |
55|* 45 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10668 | | 220 (3)| 00:00:03 |
56| 46 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
57|* 47 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
58|* 48 | INDEX RANGE SCAN | I_PO_INVOICE_B_5 | 14 | | | 1 (0)| 00:00:01 |
59| 49 | INDEX FAST FULL SCAN | PK_PO_ORDER_B | 227K| 4673K| | 287 (4)| 00:00:04 |
60| 50 | VIEW | | 52G| 31T| | 10M (16)| 34:23:39 |
61| 51 | UNION-ALL | | | | | | |
62|* 52 | HASH JOIN RIGHT OUTER | | 52G| 31T| 202M| 9173K (18)| 30:34:41 |
63| 53 | VIEW | | 1251K| 188M| | 74342 (3)| 00:14:53 |
64| 54 | HASH GROUP BY | | 1251K| 177M| 407M| 74342 (3)| 00:14:53 |
65|* 55 | HASH JOIN | | 1251K| 177M| | 32704 (4)| 00:06:33 |
66|* 56 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
67|* 57 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
68|* 58 | HASH JOIN | | 1176K| 105M| | 31300 (4)| 00:06:16 |
69|* 59 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
70|* 60 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
71| 61 | VIEW | | 267M| 124G| | 1056K (3)| 03:31:22 |
72| 62 | UNION-ALL | | | | | | |
73|* 63 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:21 |
74| 64 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
75| 65 | UNION-ALL | | | | | | |
76|* 66 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
77| 67 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
78| 68 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
79|* 69 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
80|* 70 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
81|* 71 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
82|* 72 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
83| 73 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
84| 74 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
85| 75 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
86|* 76 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
87|* 77 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
88|* 78 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
89|* 79 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
90|* 80 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
91|* 81 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
92|* 82 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
93|* 83 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
94|* 84 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
95| 85 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
96|* 86 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
97| 87 | VIEW | VW_SQ_1 | 931 | 19551 | | 26493 (4)| 00:05:18 |
98| 88 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
99|* 89 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
100|* 90 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
101|* 91 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
102|* 92 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
103|* 93 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
104|* 94 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
105|* 95 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
106| 96 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
107|* 97 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
108|* 98 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
109|* 99 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
110|*100 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
111|*101 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
112| 102 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
113| 103 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
114|*104 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
115|*105 | HASH JOIN | | 21603 | 2911K| | 728 (6)| 00:00:09 |
116|*106 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
117|*107 | HASH JOIN | | 21606 | 1941K| | 674 (5)| 00:00:09 |
118|*108 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
119|*109 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1875K| | 361 (7)| 00:00:05 |
120|*110 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
121| 111 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
122|*112 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
123|*113 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
124|*114 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
125|*115 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
126|*116 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
127|*117 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
128| 118 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
129| 119 | UNION-ALL | | | | | | |
130|*120 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
131| 121 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
132| 122 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
133|*123 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
134|*124 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
135|*125 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
136|*126 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
137| 127 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
138| 128 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
139| 129 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
140|*130 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
141|*131 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
142|*132 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
143| 133 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
144|*134 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
145|*135 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
146|*136 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
147|*137 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
148|*138 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
149| 139 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
150|*140 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
151| 141 | VIEW | VW_SQ_2 | 931 | 19551 | | 26493 (4)| 00:05:18 |
152| 142 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
153|*143 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
154|*144 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
155|*145 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
156|*146 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
157|*147 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
158|*148 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
159|*149 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
160| 150 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
161|*151 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
162|*152 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
163|*153 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
164|*154 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
165|*155 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
166|*156 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
167|*157 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
168| 158 | HASH GROUP BY | | 1251K| 204M| 454M| 1144K (4)| 03:48:58 |
169|*159 | HASH JOIN | | 1251K| 204M| | 1097K (4)| 03:39:28 |
170|*160 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
171|*161 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
172|*162 | HASH JOIN | | 1176K| 130M| | 1095K (4)| 03:39:11 |
173|*163 | HASH JOIN ANTI | | 6335 | 420K| | 1064K (4)| 03:32:56 |
174|*164 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
175| 165 | VIEW | | 267M| 5620M| | 1056K (3)| 03:31:21 |
176| 166 | UNION-ALL | | | | | | |
177|*167 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
178| 168 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
179| 169 | UNION-ALL | | | | | | |
180|*170 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
181| 171 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
182| 172 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
183|*173 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
184|*174 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
185|*175 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
186|*176 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
187| 177 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
188| 178 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
189| 179 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
190|*180 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
191|*181 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
192|*182 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
193| 183 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
194|*184 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
195|*185 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
196|*186 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
197|*187 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
198|*188 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
199| 189 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
200|*190 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
201| 191 | VIEW | VW_SQ_3 | 931 | 19551 | | 26493 (4)| 00:05:18 |
202| 192 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
203|*193 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
204|*194 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
205|*195 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
206|*196 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
207|*197 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
208|*198 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
209|*199 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
210| 200 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
211|*201 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
212|*202 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
213|*203 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
214|*204 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
215|*205 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
216| 206 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
217| 207 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
218|*208 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
219|*209 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
220|*210 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
221|*211 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
222|*212 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
223|*213 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
224|*214 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
225| 215 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
226|*216 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
227|*217 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
228|*218 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
229|*219 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
230|*220 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
231|*221 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
232| 222 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
233| 223 | UNION-ALL | | | | | | |
234|*224 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
235| 225 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
236| 226 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
237|*227 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
238|*228 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
239|*229 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
240|*230 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
241| 231 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
242| 232 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
243| 233 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
244|*234 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
245|*235 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
246|*236 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
247| 237 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
248|*238 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
249|*239 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
250|*240 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
251|*241 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
252|*242 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
253| 243 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
254|*244 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
255| 245 | VIEW | VW_SQ_4 | 931 | 19551 | | 26493 (4)| 00:05:18 |
256| 246 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
257|*247 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
258|*248 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
259|*249 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
260|*250 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
261|*251 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
262|*252 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
263|*253 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
264| 254 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
265|*255 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
266|*256 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
267|*257 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
268|*258 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
269|*259 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
270|*260 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
271|*261 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
272|*262 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
273| 263 | HASH GROUP BY | | 1221 | 251K| | 11M (27)| 39:30:43 |
274|*264 | HASH JOIN | | 1221 | 251K| | 11M (27)| 39:30:43 |
275|*265 | TABLE ACCESS BY INDEX ROWID | PO_INVOICE_B | 10 | 460 | | 2 (0)| 00:00:01 |
276| 266 | NESTED LOOPS | | 1221 | 226K| | 11M (27)| 39:30:40 |
277|*267 | HASH JOIN ANTI | | 127 | 18288 | | 11M (27)| 39:30:37 |
278| 268 | NESTED LOOPS | | 127 | 15494 | | 271 (3)| 00:00:04 |
279|*269 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10668 | | 220 (3)| 00:00:03 |
280| 270 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
281|*271 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
282| 272 | VIEW | | 52G| 1079G| | 10M (16)| 34:23:30 |
283| 273 | UNION-ALL | | | | | | |
284|*274 | HASH JOIN RIGHT OUTER | | 52G| 31T| 202M| 9172K (18)| 30:34:32 |
285| 275 | VIEW | | 1251K| 188M| | 74342 (3)| 00:14:53 |
286| 276 | HASH GROUP BY | | 1251K| 177M| 407M| 74342 (3)| 00:14:53 |
287|*277 | HASH JOIN | | 1251K| 177M| | 32704 (4)| 00:06:33 |
288|*278 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
289|*279 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
290|*280 | HASH JOIN | | 1176K| 105M| | 31300 (4)| 00:06:16 |
291|*281 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
292|*282 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
293| 283 | VIEW | | 267M| 124G| | 1056K (3)| 03:31:21 |
294| 284 | UNION-ALL | | | | | | |
295|*285 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
296| 286 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
297| 287 | UNION-ALL | | | | | | |
298|*288 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
299| 289 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
300| 290 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
301|*291 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
302|*292 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
303|*293 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
304|*294 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
305| 295 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
306| 296 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
307| 297 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
308|*298 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
309|*299 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
310|*300 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
311| 301 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
312|*302 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
313|*303 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
314|*304 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
315|*305 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
316|*306 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
317| 307 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
318|*308 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
319| 309 | VIEW | VW_SQ_5 | 931 | 19551 | | 26493 (4)| 00:05:18 |
320| 310 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
321|*311 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
322|*312 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
323|*313 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
324|*314 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
325|*315 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
326|*316 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
327|*317 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
328| 318 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
329|*319 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
330|*320 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
331|*321 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
332|*322 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
333|*323 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
334| 324 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
335| 325 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
336|*326 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
337|*327 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
338|*328 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
339|*329 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
340|*330 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
341|*331 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
342|*332 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
343| 333 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
344|*334 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
345|*335 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
346|*336 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
347|*337 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
348|*338 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
349|*339 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
350| 340 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
351| 341 | UNION-ALL | | | | | | |
352|*342 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
353| 343 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
354| 344 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
355|*345 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
356|*346 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
357|*347 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
358|*348 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
359| 349 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
360| 350 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
361| 351 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
362|*352 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
363|*353 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
364|*354 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
365| 355 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
366|*356 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
367|*357 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
368|*358 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
369|*359 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
370|*360 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
371| 361 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
372|*362 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
373| 363 | VIEW | VW_SQ_6 | 931 | 19551 | | 26493 (4)| 00:05:18 |
374| 364 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
375|*365 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
376|*366 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
377|*367 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
378|*368 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
379|*369 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
380|*370 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
381|*371 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
382| 372 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
383|*373 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
384|*374 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
385|*375 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
386|*376 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
387|*377 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
388|*378 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
389|*379 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
390| 380 | HASH GROUP BY | | 1251K| 204M| 454M| 1144K (4)| 03:48:58 |
391|*381 | HASH JOIN | | 1251K| 204M| | 1097K (4)| 03:39:28 |
392|*382 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
393|*383 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
394|*384 | HASH JOIN | | 1176K| 130M| | 1095K (4)| 03:39:11 |
395|*385 | HASH JOIN ANTI | | 6335 | 420K| | 1064K (4)| 03:32:56 |
396|*386 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
397| 387 | VIEW | | 267M| 5620M| | 1056K (3)| 03:31:21 |
398| 388 | UNION-ALL | | | | | | |
399|*389 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
400| 390 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
401| 391 | UNION-ALL | | | | | | |
402|*392 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
403| 393 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
404| 394 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
405|*395 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
406|*396 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
407|*397 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
408|*398 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
409| 399 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
410| 400 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
411| 401 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
412|*402 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
413|*403 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
414|*404 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
415| 405 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
416|*406 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
417|*407 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
418|*408 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
419|*409 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
420|*410 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
421| 411 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
422|*412 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
423| 413 | VIEW | VW_SQ_7 | 931 | 19551 | | 26493 (4)| 00:05:18 |
424| 414 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
425|*415 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
426|*416 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
427|*417 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
428|*418 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
429|*419 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
430|*420 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
431|*421 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
432| 422 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
433|*423 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
434|*424 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
435|*425 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
436|*426 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
437|*427 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
438| 428 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
439| 429 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
440|*430 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
441|*431 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
442|*432 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
443|*433 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
444|*434 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
445|*435 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
446|*436 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
447| 437 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
448|*438 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
449|*439 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
450|*440 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
451|*441 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
452|*442 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
453|*443 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
454| 444 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
455| 445 | UNION-ALL | | | | | | |
456|*446 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
457| 447 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
458| 448 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
459|*449 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
460|*450 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
461|*451 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
462|*452 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
463| 453 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
464| 454 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
465| 455 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
466|*456 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
467|*457 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
468|*458 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
469| 459 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
470|*460 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
471|*461 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
472|*462 | TI HASH JOIN RIGHT AN | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
473|*463 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
474|*464 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
475| 465 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
476|*466 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
477| 467 | VIEW | VW_SQ_8 | 931 | 19551 | | 26493 (4)| 00:05:18 |
478| 468 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
479|*469 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
480|*470 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
481|*471 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
482|*472 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
483|*473 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
484|*474 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
485|*475 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
486| 476 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
487|*477 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
488|*478 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
489|*479 | I HASH JOIN RIGHT ANT | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
490|*480 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
491|*481 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
492|*482 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
493|*483 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
494|*484 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
495|*485 | INDEX RANGE SCAN | I_PO_INVOICE_B_5 | 14 | | | 1 (0)| 00:00:01 |
496| 486 | INDEX FAST FULL SCAN | PK_PO_ORDER_B | 227K| 4673K| | 287 (4)| 00:00:04 |
497| 487 | HASH GROUP BY | | 202 | 15150 | | 25M (32)| 84:08:31 |
498|*488 | HASH JOIN ANTI | | 202 | 15150 | | 25M (32)| 84:08:31 |
499|*489 | TABLE ACCESS FULL | GT_QCYE | 203 | 10759 | | 8 (0)| 00:00:01 |
500| 490 | VIEW | | 52G| 1079G| | 23M (27)| 79:01:26 |
501| 491 | UNION-ALL | | | | | | |
502|*492 | HASH JOIN RIGHT OUTER | | 52G| 38T| | 11M (27)| 39:30:43 |
503| 493 | VIEW | | 1221 | 162K| | 770 (4)| 00:00:10 |
504| 494 | HASH GROUP BY | | 1221 | 225K| | 770 (4)| 00:00:10 |
505|*495 | HASH JOIN | | 1221 | 225K| | 769 (4)| 00:00:10 |
506|*496 | TABLE ACCESS BY INDEX ROWID | PO_INVOICE_B | 10 | 460 | | 2 (0)| 00:00:01 |
507| 497 | NESTED LOOPS | | 1221 | 200K| | 475 (2)| 00:00:06 |
508| 498 | NESTED LOOPS | | 127 | 15494 | | 271 (3)| 00:00:04 |
509|*499 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10668 | | 220 (3)| 00:00:03 |
510| 500 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
511|*501 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
512|*502 | INDEX RANGE SCAN | I_PO_INVOICE_B_5 | 14 | | | 1 (0)| 00:00:01 |
513| 503 | INDEX FAST FULL SCAN | PK_PO_ORDER_B | 227K| 4673K| | 287 (4)| 00:00:04 |
514| 504 | VIEW | | 52G| 31T| | 10M (16)| 34:23:30 |
515| 505 | UNION-ALL | | | | | | |
516|*506 | HASH JOIN RIGHT OUTER | | 52G| 31T| 202M| 9172K (18)| 30:34:32 |
517| 507 | VIEW | | 1251K| 188M| | 74342 (3)| 00:14:53 |
518| 508 | HASH GROUP BY | | 1251K| 177M| 407M| 74342 (3)| 00:14:53 |
519|*509 | HASH JOIN | | 1251K| 177M| | 32704 (4)| 00:06:33 |
520|*510 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
521|*511 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
522|*512 | HASH JOIN | | 1176K| 105M| | 31300 (4)| 00:06:16 |
523|*513 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
524|*514 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
525| 515 | VIEW | | 267M| 124G| | 1056K (3)| 03:31:21 |
526| 516 | UNION-ALL | | | | | | |
527|*517 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
528| 518 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
529| 519 | UNION-ALL | | | | | | |
530|*520 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
531| 521 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
532| 522 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
533|*523 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
534|*524 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
535|*525 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
536|*526 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
537| 527 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
538| 528 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
539| 529 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
540|*530 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
541|*531 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
542|*532 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
543| 533 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
544|*534 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
545|*535 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
546|*536 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
547|*537 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
548|*538 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
549| 539 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
550|*540 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
551| 541 | VIEW | VW_SQ_9 | 931 | 19551 | | 26493 (4)| 00:05:18 |
552| 542 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
553|*543 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
554|*544 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
555|*545 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
556|*546 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
557|*547 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
558|*548 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
559|*549 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
560| 550 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
561|*551 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
562|*552 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
563|*553 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
564|*554 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
565|*555 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
566| 556 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
567| 557 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
568|*558 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
569|*559 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
570|*560 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
571|*561 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
572|*562 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
573|*563 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
574|*564 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
575| 565 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
576|*566 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
577|*567 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
578|*568 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
579|*569 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
580|*570 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
581|*571 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
582| 572 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
583| 573 | UNION-ALL | | | | | | |
584|*574 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
585| 575 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
586| 576 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
587|*577 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
588|*578 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
589|*579 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
590|*580 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
591| 581 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
592| 582 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
593| 583 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
594|*584 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
595|*585 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
596|*586 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
597| 587 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
598|*588 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
599|*589 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
600|*590 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
601|*591 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
602|*592 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
603| 593 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
604|*594 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
605| 595 | VIEW | VW_SQ_10 | 931 | 19551 | | 26493 (4)| 00:05:18 |
606| 596 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
607|*597 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
608|*598 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
609|*599 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
610|*600 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
611|*601 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
612|*602 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
613|*603 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
614| 604 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
615|*605 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
616|*606 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
617|*607 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
618|*608 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
619|*609 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
620|*610 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
621|*611 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
622| 612 | HASH GROUP BY | | 1251K| 204M| 454M| 1144K (4)| 03:48:58 |
623|*613 | HASH JOIN | | 1251K| 204M| | 1097K (4)| 03:39:28 |
624|*614 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
625|*615 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
626|*616 | HASH JOIN | | 1176K| 130M| | 1095K (4)| 03:39:11 |
627|*617 | HASH JOIN ANTI | | 6335 | 420K| | 1064K (4)| 03:32:56 |
628|*618 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
629| 619 | VIEW | | 267M| 5620M| | 1056K (3)| 03:31:21 |
630| 620 | UNION-ALL | | | | | | |
631|*621 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
632| 622 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
633| 623 | UNION-ALL | | | | | | |
634|*624 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
635| 625 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
636| 626 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
637|*627 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
638|*628 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
639|*629 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
640|*630 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
641| 631 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
642| 632 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
643| 633 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
644|*634 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
645|*635 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
646|*636 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
647| 637 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
648|*638 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
649|*639 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
650|*640 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
651|*641 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
652|*642 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
653| 643 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
654|*644 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
655| 645 | VIEW | VW_SQ_11 | 931 | 19551 | | 26493 (4)| 00:05:18 |
656| 646 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
657|*647 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
658|*648 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
659|*649 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
660|*650 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
661|*651 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
662|*652 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
663|*653 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
664| 654 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
665|*655 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
666|*656 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
667|*657 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
668|*658 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
669|*659 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
670| 660 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
671| 661 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
672|*662 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
673|*663 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
674|*664 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
675|*665 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
676|*666 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
677|*667 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
678|*668 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
679| 669 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
680|*670 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
681|*671 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
682|*672 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
683|*673 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
684|*674 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
685|*675 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
686| 676 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
687| 677 | UNION-ALL | | | | | | |
688|*678 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
689| 679 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
690| 680 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
691|*681 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
692|*682 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
693|*683 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
694|*684 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
695| 685 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
696| 686 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
697| 687 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
698|*688 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
699|*689 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
700|*690 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
701| 691 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
702|*692 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
703|*693 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
704|*694 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
705|*695 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
706|*696 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
707| 697 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
708|*698 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
709| 699 | VIEW | VW_SQ_12 | 931 | 19551 | | 26493 (4)| 00:05:18 |
710| 700 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
711|*701 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
712|*702 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
713|*703 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
714|*704 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
715|*705 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
716|*706 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
717|*707 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
718| 708 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
719|*709 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
720|*710 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
721|*711 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
722|*712 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
723|*713 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
724|*714 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
725|*715 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
726|*716 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
727| 717 | HASH GROUP BY | | 1221 | 251K| | 11M (27)| 39:30:43 |
728|*718 | HASH JOIN | | 1221 | 251K| | 11M (27)| 39:30:43 |
729|*719 | TABLE ACCESS BY INDEX ROWID | PO_INVOICE_B | 10 | 460 | | 2 (0)| 00:00:01 |
730| 720 | NESTED LOOPS | | 1221 | 226K| | 11M (27)| 39:30:40 |
731|*721 | HASH JOIN ANTI | | 127 | 18288 | | 11M (27)| 39:30:37 |
732| 722 | NESTED LOOPS | | 127 | 15494 | | 271 (3)| 00:00:04 |
733|*723 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10668 | | 220 (3)| 00:00:03 |
734| 724 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
735|*725 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
736| 726 | VIEW | | 52G| 1079G| | 10M (16)| 34:23:30 |
737| 727 | UNION-ALL | | | | | | |
738|*728 | HASH JOIN RIGHT OUTER | | 52G| 31T| 202M| 9172K (18)| 30:34:32 |
739| 729 | VIEW | | 1251K| 188M| | 74342 (3)| 00:14:53 |
740| 730 | HASH GROUP BY | | 1251K| 177M| 407M| 74342 (3)| 00:14:53 |
741|*731 | HASH JOIN | | 1251K| 177M| | 32704 (4)| 00:06:33 |
742|*732 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
743|*733 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
744|*734 | HASH JOIN | | 1176K| 105M| | 31300 (4)| 00:06:16 |
745|*735 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
746|*736 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
747| 737 | VIEW | | 267M| 124G| | 1056K (3)| 03:31:21 |
748| 738 | UNION-ALL | | | | | | |
749|*739 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
750| 740 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
751| 741 | UNION-ALL | | | | | | |
752|*742 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
753| 743 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
754| 744 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
755|*745 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
756|*746 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
757|*747 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
758|*748 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
759| 749 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
760| 750 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
761| 751 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
762|*752 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
763|*753 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
764|*754 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
765| 755 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
766|*756 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
767|*757 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
768|*758 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
769|*759 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
770|*760 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
771| 761 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
772|*762 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
773| 763 | VIEW | VW_SQ_13 | 931 | 19551 | | 26493 (4)| 00:05:18 |
774| 764 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
775|*765 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
776|*766 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
777|*767 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
778|*768 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
779|*769 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
780|*770 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
781|*771 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
782| 772 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
783|*773 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
784|*774 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
785|*775 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
786|*776 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
787|*777 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
788| 778 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
789| 779 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
790|*780 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
791|*781 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
792|*782 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
793|*783 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
794|*784 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
795|*785 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
796|*786 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
797| 787 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
798|*788 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
799|*789 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
800|*790 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
801|*791 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
802|*792 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
803|*793 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
804| 794 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
805| 795 | UNION-ALL | | | | | | |
806|*796 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
807| 797 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
808| 798 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
809|*799 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
810|*800 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
811|*801 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
812|*802 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
813| 803 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
814| 804 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
815| 805 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
816|*806 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
817|*807 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
818|*808 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
819| 809 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
820|*810 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
821|*811 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
822|*812 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
823|*813 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
824|*814 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
825| 815 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
826|*816 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
827| 817 | VIEW | VW_SQ_14 | 931 | 19551 | | 26493 (4)| 00:05:18 |
828| 818 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
829|*819 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
830|*820 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
831|*821 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
832|*822 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
833|*823 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
834|*824 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
835|*825 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
836| 826 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
837|*827 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
838|*828 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
839|*829 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
840|*830 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
841|*831 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
842|*832 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
843|*833 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
844| 834 | HASH GROUP BY | | 1251K| 204M| 454M| 1144K (4)| 03:48:58 |
845|*835 | HASH JOIN | | 1251K| 204M| | 1097K (4)| 03:39:28 |
846|*836 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
847|*837 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
848|*838 | HASH JOIN | | 1176K| 130M| | 1095K (4)| 03:39:11 |
849|*839 | HASH JOIN ANTI | | 6335 | 420K| | 1064K (4)| 03:32:56 |
850|*840 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
851| 841 | VIEW | | 267M| 5620M| | 1056K (3)| 03:31:21 |
852| 842 | UNION-ALL | | | | | | |
853|*843 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
854| 844 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
855| 845 | UNION-ALL | | | | | | |
856|*846 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
857| 847 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
858| 848 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
859|*849 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
860|*850 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
861|*851 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
862|*852 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
863| 853 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
864| 854 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
865| 855 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
866|*856 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
867|*857 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
868|*858 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
869| 859 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
870|*860 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
871|*861 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
872|*862 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
873|*863 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
874|*864 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
875| 865 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
876|*866 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
877| 867 | VIEW | VW_SQ_15 | 931 | 19551 | | 26493 (4)| 00:05:18 |
878| 868 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
879|*869 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
880|*870 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
881|*871 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
882|*872 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
883|*873 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
884|*874 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
885|*875 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
886| 876 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
887|*877 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
888|*878 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
889|*879 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
890|*880 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
891|*881 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
892| 882 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
893| 883 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
894|*884 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
895|*885 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
896|*886 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
897|*887 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
898|*888 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
899|*889 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
900|*890 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
901| 891 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
902|*892 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
903|*893 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
904|*894 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
905|*895 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
906|*896 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
907|*897 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
908| 898 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
909| 899 | UNION-ALL | | | | | | |
910|*900 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
911| 901 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
912| 902 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
913|*903 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
914|*904 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
915|*905 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
916|*906 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
917| 907 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
918| 908 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
919| 909 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
920|*910 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
921|*911 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
922|*912 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
923| 913 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
924|*914 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
925|*915 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
926|*916 | NTI HASH JOIN RIGHT A | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
927|*917 | L TABLE ACCESS FUL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
928|*918 | L TABLE ACCESS FUL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
929| 919 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
930|*920 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
931| 921 | VIEW | VW_SQ_16 | 931 | 19551 | | 26493 (4)| 00:05:18 |
932| 922 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
933|*923 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
934|*924 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
935|*925 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
936|*926 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
937|*927 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
938|*928 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
939|*929 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
940| 930 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
941|*931 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
942|*932 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
943|*933 | TI HASH JOIN RIGHT AN | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
944|*934 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
945|*935 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
946|*936 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
947|*937 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
948|*938 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
949|*939 | INDEX RANGE SCAN | I_PO_INVOICE_B_5 | 14 | | | 1 (0)| 00:00:01 |
950| 940 | INDEX FAST FULL SCAN | PK_PO_ORDER_B | 227K| 4673K| | 287 (4)| 00:00:04 |
951| 941 | HASH GROUP BY | | 1221 | 251K| | 52M (34)|173:33:36 |
952| 942 | NESTED LOOPS | | 1221 | 251K| | 52M (34)|173:33:36 |
953| 943 | NESTED LOOPS | | 1221 | 221K| | 52M (34)|173:33:24 |
954|*944 | HASH JOIN ANTI | | 127 | 17907 | | 52M (34)|173:33:22 |
955| 945 | NESTED LOOPS | | 127 | 15113 | | 271 (3)| 00:00:04 |
956|*946 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10287 | | 220 (3)| 00:00:03 |
957| 947 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
958|*948 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
959| 949 | VIEW | | 53G| 1095G| | 50M (32)|168:21:38 |
960| 950 | UNION-ALL | | | | | | |
961|*951 | HASH JOIN RIGHT OUTER | | 53G| 52T| | 25M (32)| 84:13:07 |
962| 952 | VIEW | | 203 | 58058 | | 9 (12)| 00:00:01 |
963| 953 | HASH GROUP BY | | 203 | 10759 | | 9 (12)| 00:00:01 |
964|*954 | TABLE ACCESS FULL | GT_QCYE | 203 | 10759 | | 8 (0)| 00:00:01 |
965| 955 | VIEW | | 52G| 38T| | 23M (27)| 79:01:26 |
966| 956 | UNION-ALL | | | | | | |
967|*957 | HASH JOIN RIGHT OUTER | | 52G| 38T| | 11M (27)| 39:30:43 |
968| 958 | VIEW | | 1221 | 162K| | 770 (4)| 00:00:10 |
969| 959 | HASH GROUP BY | | 1221 | 225K| | 770 (4)| 00:00:10 |
970|*960 | HASH JOIN | | 1221 | 225K| | 769 (4)| 00:00:10 |
971|*961 | TABLE ACCESS BY INDEX ROWID | PO_INVOICE_B | 10 | 460 | | 2 (0)| 00:00:01 |
972| 962 | NESTED LOOPS | | 1221 | 200K| | 475 (2)| 00:00:06 |
973| 963 | NESTED LOOPS | | 127 | 15494 | | 271 (3)| 00:00:04 |
974|*964 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10668 | | 220 (3)| 00:00:03 |
975| 965 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
976|*966 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
977|*967 | INDEX RANGE SCAN | I_PO_INVOICE_B_5 | 14 | | | 1 (0)| 00:00:01 |
978| 968 | INDEX FAST FULL SCAN | PK_PO_ORDER_B | 227K| 4673K| | 287 (4)| 00:00:04 |
979| 969 | VIEW | | 52G| 31T| | 10M (16)| 34:23:30 |
980| 970 | UNION-ALL | | | | | | |
981|*971 | HASH JOIN RIGHT OUTER | | 52G| 31T| 202M| 9172K (18)| 30:34:32 |
982| 972 | VIEW | | 1251K| 188M| | 74342 (3)| 00:14:53 |
983| 973 | HASH GROUP BY | | 1251K| 177M| 407M| 74342 (3)| 00:14:53 |
984|*974 | HASH JOIN | | 1251K| 177M| | 32704 (4)| 00:06:33 |
985|*975 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
986|*976 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
987|*977 | HASH JOIN | | 1176K| 105M| | 31300 (4)| 00:06:16 |
988|*978 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
989|*979 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
990| 980 | VIEW | | 267M| 124G| | 1056K (3)| 03:31:21 |
991| 981 | UNION-ALL | | | | | | |
992|*982 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
993| 983 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
994| 984 | UNION-ALL | | | | | | |
995|*985 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
996| 986 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
997| 987 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
998|*988 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
999|*989 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1000|*990 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1001|*991 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1002| 992 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1003| 993 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1004| 994 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1005|*995 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1006|*996 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1007|*997 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1008| 998 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1009|*999 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1010|1000 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1011|1001 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1012|1002 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1013|1003 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1014|1004 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1015|1005 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1016|1006 | VIEW | VW_SQ_17 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1017|1007 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1018|1008 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1019|1009 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1020|1010 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1021|1011 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1022|1012 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1023|1013 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1024|1014 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1025|1015 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1026|1016 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1027|1017 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1028|1018 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1029|1019 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1030|1020 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1031|1021 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
1032|1022 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
1033|1023 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
1034|1024 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
1035|1025 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1036|1026 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
1037|1027 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1038|1028 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1039|1029 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1040|1030 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
1041|1031 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
1042|1032 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
1043|1033 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1044|1034 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
1045|1035 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
1046|1036 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1047|1037 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
1048|1038 | UNION-ALL | | | | | | |
1049|1039 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1050|1040 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1051|1041 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1052|1042 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1053|1043 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1054|1044 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1055|1045 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1056|1046 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1057|1047 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1058|1048 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1059|1049 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1060|1050 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1061|1051 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1062|1052 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1063|1053 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1064|1054 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1065|1055 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1066|1056 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1067|1057 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1068|1058 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1069|1059 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1070|1060 | VIEW | VW_SQ_18 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1071|1061 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1072|1062 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1073|1063 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1074|1064 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1075|1065 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1076|1066 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1077|1067 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1078|1068 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1079|1069 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1080|1070 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1081|1071 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1082|1072 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1083|1073 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1084|1074 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1085|1075 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1086|1076 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1087|1077 | HASH GROUP BY | | 1251K| 204M| 454M| 1144K (4)| 03:48:58 |
1088|1078 | HASH JOIN | | 1251K| 204M| | 1097K (4)| 03:39:28 |
1089|1079 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
1090|1080 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
1091|1081 | HASH JOIN | | 1176K| 130M| | 1095K (4)| 03:39:11 |
1092|1082 | HASH JOIN ANTI | | 6335 | 420K| | 1064K (4)| 03:32:56 |
1093|1083 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
1094|1084 | VIEW | | 267M| 5620M| | 1056K (3)| 03:31:21 |
1095|1085 | UNION-ALL | | | | | | |
1096|1086 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
1097|1087 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
1098|1088 | UNION-ALL | | | | | | |
1099|1089 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1100|1090 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1101|1091 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1102|1092 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1103|1093 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1104|1094 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1105|1095 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1106|1096 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1107|1097 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1108|1098 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1109|1099 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1110|1100 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1111|1101 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1112|1102 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1113|1103 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1114|1104 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1115|1105 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1116|1106 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1117|1107 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1118|1108 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1119|1109 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1120|1110 | VIEW | VW_SQ_19 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1121|1111 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1122|1112 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1123|1113 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1124|1114 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1125|1115 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1126|1116 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1127|1117 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1128|1118 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1129|1119 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1130|1120 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1131|1121 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1132|1122 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1133|1123 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1134|1124 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1135|1125 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
1136|1126 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
1137|1127 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
1138|1128 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
1139|1129 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1140|1130 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
1141|1131 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1142|1132 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1143|1133 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1144|1134 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
1145|1135 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
1146|1136 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
1147|1137 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1148|1138 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
1149|1139 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
1150|1140 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1151|1141 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
1152|1142 | UNION-ALL | | | | | | |
1153|1143 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1154|1144 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1155|1145 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1156|1146 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1157|1147 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1158|1148 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1159|1149 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1160|1150 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1161|1151 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1162|1152 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1163|1153 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1164|1154 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1165|1155 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1166|1156 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1167|1157 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1168|1158 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1169|1159 | I HASH JOIN RIGHT ANT | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1170|1160 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1171|1161 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1172|1162 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1173|1163 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1174|1164 | VIEW | VW_SQ_20 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1175|1165 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1176|1166 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1177|1167 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1178|1168 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1179|1169 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1180|1170 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1181|1171 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1182|1172 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1183|1173 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1184|1174 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1185|1175 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1186|1176 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1187|1177 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1188|1178 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1189|1179 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1190|1180 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1191|1181 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
1192|1182 | HASH GROUP BY | | 1221 | 251K| | 11M (27)| 39:30:43 |
1193|1183 | HASH JOIN | | 1221 | 251K| | 11M (27)| 39:30:43 |
1194|1184 | TABLE ACCESS BY INDEX ROWID | PO_INVOICE_B | 10 | 460 | | 2 (0)| 00:00:01 |
1195|1185 | NESTED LOOPS | | 1221 | 226K| | 11M (27)| 39:30:40 |
1196|1186 | HASH JOIN ANTI | | 127 | 18288 | | 11M (27)| 39:30:37 |
1197|1187 | NESTED LOOPS | | 127 | 15494 | | 271 (3)| 00:00:04 |
1198|1188 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10668 | | 220 (3)| 00:00:03 |
1199|1189 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
1200|1190 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
1201|1191 | VIEW | | 52G| 1079G| | 10M (16)| 34:23:30 |
1202|1192 | UNION-ALL | | | | | | |
1203|1193 | HASH JOIN RIGHT OUTER | | 52G| 31T| 202M| 9172K (18)| 30:34:32 |
1204|1194 | VIEW | | 1251K| 188M| | 74342 (3)| 00:14:53 |
1205|1195 | HASH GROUP BY | | 1251K| 177M| 407M| 74342 (3)| 00:14:53 |
1206|1196 | HASH JOIN | | 1251K| 177M| | 32704 (4)| 00:06:33 |
1207|1197 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
1208|1198 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
1209|1199 | HASH JOIN | | 1176K| 105M| | 31300 (4)| 00:06:16 |
1210|1200 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
1211|1201 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
1212|1202 | VIEW | | 267M| 124G| | 1056K (3)| 03:31:21 |
1213|1203 | UNION-ALL | | | | | | |
1214|1204 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
1215|1205 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
1216|1206 | UNION-ALL | | | | | | |
1217|1207 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1218|1208 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1219|1209 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1220|1210 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1221|1211 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1222|1212 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1223|1213 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1224|1214 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1225|1215 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1226|1216 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1227|1217 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1228|1218 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1229|1219 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1230|1220 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1231|1221 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1232|1222 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1233|1223 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1234|1224 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1235|1225 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1236|1226 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1237|1227 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1238|1228 | VIEW | VW_SQ_21 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1239|1229 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1240|1230 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1241|1231 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1242|1232 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1243|1233 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1244|1234 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1245|1235 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1246|1236 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1247|1237 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1248|1238 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1249|1239 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1250|1240 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1251|1241 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1252|1242 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1253|1243 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
1254|1244 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
1255|1245 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
1256|1246 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
1257|1247 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1258|1248 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
1259|1249 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1260|1250 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1261|1251 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1262|1252 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
1263|1253 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
1264|1254 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
1265|1255 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1266|1256 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
1267|1257 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
1268|1258 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1269|1259 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
1270|1260 | UNION-ALL | | | | | | |
1271|1261 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1272|1262 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1273|1263 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1274|1264 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1275|1265 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1276|1266 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1277|1267 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1278|1268 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1279|1269 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1280|1270 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1281|1271 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1282|1272 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1283|1273 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1284|1274 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1285|1275 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1286|1276 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1287|1277 | TI HASH JOIN RIGHT AN | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1288|1278 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1289|1279 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1290|1280 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1291|1281 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1292|1282 | VIEW | VW_SQ_22 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1293|1283 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1294|1284 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1295|1285 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1296|1286 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1297|1287 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1298|1288 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1299|1289 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1300|1290 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1301|1291 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1302|1292 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1303|1293 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1304|1294 | I HASH JOIN RIGHT ANT | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1305|1295 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1306|1296 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1307|1297 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1308|1298 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1309|1299 | HASH GROUP BY | | 1251K| 204M| 454M| 1144K (4)| 03:48:58 |
1310|1300 | HASH JOIN | | 1251K| 204M| | 1097K (4)| 03:39:28 |
1311|1301 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
1312|1302 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
1313|1303 | HASH JOIN | | 1176K| 130M| | 1095K (4)| 03:39:11 |
1314|1304 | HASH JOIN ANTI | | 6335 | 420K| | 1064K (4)| 03:32:56 |
1315|1305 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
1316|1306 | VIEW | | 267M| 5620M| | 1056K (3)| 03:31:21 |
1317|1307 | UNION-ALL | | | | | | |
1318|1308 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
1319|1309 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
1320|1310 | UNION-ALL | | | | | | |
1321|1311 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1322|1312 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1323|1313 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1324|1314 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1325|1315 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1326|1316 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1327|1317 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1328|1318 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1329|1319 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1330|1320 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1331|1321 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1332|1322 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1333|1323 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1334|1324 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1335|1325 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1336|1326 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1337|1327 | I HASH JOIN RIGHT ANT | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1338|1328 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1339|1329 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1340|1330 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1341|1331 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1342|1332 | VIEW | VW_SQ_23 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1343|1333 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1344|1334 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1345|1335 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1346|1336 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1347|1337 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1348|1338 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1349|1339 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1350|1340 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1351|1341 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1352|1342 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1353|1343 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1354|1344 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1355|1345 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1356|1346 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1357|1347 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
1358|1348 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
1359|1349 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
1360|1350 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
1361|1351 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1362|1352 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
1363|1353 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1364|1354 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1365|1355 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1366|1356 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
1367|1357 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
1368|1358 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
1369|1359 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1370|1360 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
1371|1361 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
1372|1362 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1373|1363 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
1374|1364 | UNION-ALL | | | | | | |
1375|1365 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1376|1366 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1377|1367 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1378|1368 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1379|1369 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1380|1370 | L TABLE ACCESS FUL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1381|1371 | L TABLE ACCESS FUL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1382|1372 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1383|1373 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1384|1374 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1385|1375 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1386|1376 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1387|1377 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1388|1378 | L TABLE ACCESS FUL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1389|1379 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1390|1380 | LL TABLE ACCESS FU | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1391|1381 | ANTI HASH JOIN RIGHT | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1392|1382 | ULL TABLE ACCESS F | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1393|1383 | ULL TABLE ACCESS F | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1394|1384 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1395|1385 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1396|1386 | VIEW | VW_SQ_24 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1397|1387 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1398|1388 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1399|1389 | L TABLE ACCESS FUL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1400|1390 | L TABLE ACCESS FUL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1401|1391 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1402|1392 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1403|1393 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1404|1394 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1405|1395 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1406|1396 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1407|1397 | L TABLE ACCESS FUL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1408|1398 | ANTI HASH JOIN RIGHT | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1409|1399 | LL TABLE ACCESS FU | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1410|1400 | LL TABLE ACCESS FU | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1411|1401 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1412|1402 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1413|1403 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
1414|1404 | INDEX RANGE SCAN | I_PO_INVOICE_B_5 | 14 | | | 1 (0)| 00:00:01 |
1415|1405 | INDEX FAST FULL SCAN | PK_PO_ORDER_B | 227K| 4673K| | 287 (4)| 00:00:04 |
1416|1406 | HASH GROUP BY | | 202 | 15150 | | 25M (32)| 84:08:31 |
1417|1407 | HASH JOIN ANTI | | 202 | 15150 | | 25M (32)| 84:08:31 |
1418|1408 | TABLE ACCESS FULL | GT_QCYE | 203 | 10759 | | 8 (0)| 00:00:01 |
1419|1409 | VIEW | | 52G| 1079G| | 23M (27)| 79:01:26 |
1420|1410 | UNION-ALL | | | | | | |
1421|1411 | HASH JOIN RIGHT OUTER | | 52G| 38T| | 11M (27)| 39:30:43 |
1422|1412 | VIEW | | 1221 | 162K| | 770 (4)| 00:00:10 |
1423|1413 | HASH GROUP BY | | 1221 | 225K| | 770 (4)| 00:00:10 |
1424|1414 | HASH JOIN | | 1221 | 225K| | 769 (4)| 00:00:10 |
1425|1415 | TABLE ACCESS BY INDEX ROWID | PO_INVOICE_B | 10 | 460 | | 2 (0)| 00:00:01 |
1426|1416 | NESTED LOOPS | | 1221 | 200K| | 475 (2)| 00:00:06 |
1427|1417 | NESTED LOOPS | | 127 | 15494 | | 271 (3)| 00:00:04 |
1428|1418 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10668 | | 220 (3)| 00:00:03 |
1429|1419 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
1430|1420 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
1431|1421 | INDEX RANGE SCAN | I_PO_INVOICE_B_5 | 14 | | | 1 (0)| 00:00:01 |
1432|1422 | INDEX FAST FULL SCAN | PK_PO_ORDER_B | 227K| 4673K| | 287 (4)| 00:00:04 |
1433|1423 | VIEW | | 52G| 31T| | 10M (16)| 34:23:30 |
1434|1424 | UNION-ALL | | | | | | |
1435|1425 | HASH JOIN RIGHT OUTER | | 52G| 31T| 202M| 9172K (18)| 30:34:32 |
1436|1426 | VIEW | | 1251K| 188M| | 74342 (3)| 00:14:53 |
1437|1427 | HASH GROUP BY | | 1251K| 177M| 407M| 74342 (3)| 00:14:53 |
1438|1428 | HASH JOIN | | 1251K| 177M| | 32704 (4)| 00:06:33 |
1439|1429 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
1440|1430 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
1441|1431 | HASH JOIN | | 1176K| 105M| | 31300 (4)| 00:06:16 |
1442|1432 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
1443|1433 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
1444|1434 | VIEW | | 267M| 124G| | 1056K (3)| 03:31:21 |
1445|1435 | UNION-ALL | | | | | | |
1446|1436 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
1447|1437 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
1448|1438 | UNION-ALL | | | | | | |
1449|1439 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1450|1440 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1451|1441 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1452|1442 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1453|1443 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1454|1444 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1455|1445 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1456|1446 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1457|1447 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1458|1448 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1459|1449 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1460|1450 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1461|1451 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1462|1452 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1463|1453 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1464|1454 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1465|1455 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1466|1456 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1467|1457 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1468|1458 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1469|1459 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1470|1460 | VIEW | VW_SQ_25 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1471|1461 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1472|1462 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1473|1463 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1474|1464 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1475|1465 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1476|1466 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1477|1467 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1478|1468 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1479|1469 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1480|1470 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1481|1471 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1482|1472 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1483|1473 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1484|1474 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1485|1475 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
1486|1476 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
1487|1477 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
1488|1478 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
1489|1479 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1490|1480 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
1491|1481 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1492|1482 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1493|1483 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1494|1484 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
1495|1485 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
1496|1486 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
1497|1487 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1498|1488 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
1499|1489 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
1500|1490 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1501|1491 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
1502|1492 | UNION-ALL | | | | | | |
1503|1493 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1504|1494 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1505|1495 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1506|1496 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1507|1497 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1508|1498 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1509|1499 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1510|1500 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1511|1501 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1512|1502 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1513|1503 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1514|1504 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1515|1505 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1516|1506 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1517|1507 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1518|1508 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1519|1509 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1520|1510 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1521|1511 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1522|1512 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1523|1513 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1524|1514 | VIEW | VW_SQ_26 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1525|1515 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1526|1516 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1527|1517 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1528|1518 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1529|1519 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1530|1520 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1531|1521 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1532|1522 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1533|1523 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1534|1524 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1535|1525 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1536|1526 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1537|1527 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1538|1528 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1539|1529 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1540|1530 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1541|1531 | HASH GROUP BY | | 1251K| 204M| 454M| 1144K (4)| 03:48:58 |
1542|1532 | HASH JOIN | | 1251K| 204M| | 1097K (4)| 03:39:28 |
1543|1533 | TABLE ACCESS BY INDEX ROWID | ARAP_DJZB | 25033 | 1344K| | 1366 (1)| 00:00:17 |
1544|1534 | INDEX RANGE SCAN | I_ARAP_DJZB_004 | 24211 | | | 85 (2)| 00:00:02 |
1545|1535 | HASH JOIN | | 1176K| 130M| | 1095K (4)| 03:39:11 |
1546|1536 | HASH JOIN ANTI | | 6335 | 420K| | 1064K (4)| 03:32:56 |
1547|1537 | TABLE ACCESS FULL | BD_CUBASDOC | 6336 | 284K| | 66 (26)| 00:00:01 |
1548|1538 | VIEW | | 267M| 5620M| | 1056K (3)| 03:31:21 |
1549|1539 | UNION-ALL | | | | | | |
1550|1540 | HASH JOIN OUTER | | 262M| 121G| 55M| 616K (3)| 02:03:20 |
1551|1541 | VIEW | | 166K| 53M| | 133K (4)| 00:26:41 |
1552|1542 | UNION-ALL | | | | | | |
1553|1543 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1554|1544 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1555|1545 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1556|1546 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1557|1547 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1558|1548 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1559|1549 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1560|1550 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1561|1551 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1562|1552 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1563|1553 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1564|1554 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1565|1555 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1566|1556 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1567|1557 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1568|1558 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1569|1559 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1570|1560 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1571|1561 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1572|1562 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1573|1563 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1574|1564 | VIEW | VW_SQ_27 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1575|1565 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1576|1566 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1577|1567 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1578|1568 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1579|1569 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1580|1570 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1581|1571 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1582|1572 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1583|1573 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1584|1574 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1585|1575 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1586|1576 | HASH JOIN RIGHT ANTI | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1587|1577 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1588|1578 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1589|1579 | VIEW | | 10M| 1515M| | 391K (2)| 01:18:18 |
1590|1580 | HASH GROUP BY | | 10M| 1611M| 3492M| 391K (2)| 01:18:18 |
1591|1581 | HASH JOIN | | 10M| 1611M| 3168K| 16451 (6)| 00:03:18 |
1592|1582 | HASH JOIN | | 21601 | 2911K| | 728 (6)| 00:00:09 |
1593|1583 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1594|1584 | HASH JOIN | | 21605 | 1941K| | 674 (5)| 00:00:09 |
1595|1585 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1596|1586 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1597|1587 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1598|1588 | HASH GROUP BY | | 5206K| 943M| 2981M| 440K (3)| 01:28:02 |
1599|1589 | HASH JOIN | | 10M| 1822M| 3632K| 149K (4)| 00:29:59 |
1600|1590 | HASH JOIN | | 21598 | 3374K| | 134K (4)| 00:26:50 |
1601|1591 | TABLE ACCESS FULL | GT_INVOICE_H | 21430 | 1004K| | 311 (3)| 00:00:04 |
1602|1592 | HASH JOIN | | 43630 | 4772K| | 133K (4)| 00:26:46 |
1603|1593 | HASH JOIN ANTI | | 6364 | 422K| | 133K (4)| 00:26:42 |
1604|1594 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1605|1595 | VIEW | | 166K| 3571K| | 133K (4)| 00:26:41 |
1606|1596 | UNION-ALL | | | | | | |
1607|1597 | HASH JOIN OUTER | | 21756 | 6713K| | 66505 (4)| 00:13:19 |
1608|1598 | VIEW | | 931 | 143K| | 26545 (4)| 00:05:19 |
1609|1599 | HASH GROUP BY | | 931 | 119K| | 26545 (4)| 00:05:19 |
1610|1600 | HASH JOIN | | 931 | 119K| | 26544 (4)| 00:05:19 |
1611|1601 | HASH JOIN | | 928 | 78880 | | 26492 (4)| 00:05:18 |
1612|1602 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 139K| | 26138 (4)| 00:05:14 |
1613|1603 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 532K| | 353 (3)| 00:00:05 |
1614|1604 | TABLE ACCESS FULL | BD_CUBASDOC | 6366 | 285K| | 52 (6)| 00:00:01 |
1615|1605 | VIEW | | 148K| 22M| | 39955 (3)| 00:08:00 |
1616|1606 | HASH GROUP BY | | 148K| 27M| 59M| 39955 (3)| 00:08:00 |
1617|1607 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1618|1608 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1619|1609 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1620|1610 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1621|1611 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1622|1612 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1623|1613 | TI HASH JOIN RIGHT AN | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1624|1614 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1625|1615 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1626|1616 | HASH GROUP BY | | 144K| 29M| 62M| 66898 (4)| 00:13:23 |
1627|1617 | HASH JOIN RIGHT ANTI | | 144K| 29M| | 60039 (4)| 00:12:01 |
1628|1618 | VIEW | VW_SQ_28 | 931 | 19551 | | 26493 (4)| 00:05:18 |
1629|1619 | NESTED LOOPS | | 931 | 91238 | | 26493 (4)| 00:05:18 |
1630|1620 | HASH JOIN | | 928 | 71456 | | 26492 (4)| 00:05:18 |
1631|1621 | TABLE ACCESS FULL | GT_MEASURE_H | 2510 | 129K| | 26138 (4)| 00:05:14 |
1632|1622 | TABLE ACCESS FULL | GT_POORDER_H | 19479 | 456K| | 353 (3)| 00:00:05 |
1633|1623 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | 21 | | 1 (0)| 00:00:01 |
1634|1624 | HASH JOIN | | 148K| 27M| | 33542 (4)| 00:06:43 |
1635|1625 | TABLE ACCESS FULL | BD_CUBASDOC | 6365 | 285K| | 52 (6)| 00:00:01 |
1636|1626 | HASH JOIN | | 148K| 21M| 2304K| 33484 (4)| 00:06:42 |
1637|1627 | TABLE ACCESS FULL | BD_CUMANDOC | 43648 | 1790K| | 360 (7)| 00:00:05 |
1638|1628 | HASH JOIN | | 146K| 15M| 3824K| 32165 (4)| 00:06:26 |
1639|1629 | TABLE ACCESS FULL | GT_GENERAL_H | 68684 | 3018K| | 1414 (3)| 00:00:17 |
1640|1630 | I HASH JOIN RIGHT ANT | | 165K| 9M| 32M| 29964 (4)| 00:06:00 |
1641|1631 | TABLE ACCESS FULL | GT_INVOICE_B | 1152K| 19M| | 13080 (4)| 00:02:37 |
1642|1632 | TABLE ACCESS FULL | GT_GENERAL_B | 1163K| 49M| | 11983 (4)| 00:02:24 |
1643|1633 | TABLE ACCESS FULL | BD_CUMANDOC | 43644 | 1875K| | 361 (7)| 00:00:05 |
1644|1634 | TABLE ACCESS FULL | GT_INVOICE_B | 1086K| 31M| | 13080 (4)| 00:02:37 |
1645|1635 | TABLE ACCESS FULL | ARAP_DJFB | 1178K| 53M| | 31199 (4)| 00:06:15 |
1646|1636 | HASH GROUP BY | | 1221 | 251K| | 11M (27)| 39:30:43 |
1647|1637 | HASH JOIN | | 1221 | 251K| | 11M (27)| 39:30:43 |
1648|1638 | TABLE ACCESS BY INDEX ROWID | PO_INVOICE_B | 10 | 460 | | 2 (0)| 00:00:01 |
1649|1639 | NESTED LOOPS | | 1221 | 226K| | 11M (27)| 39:30:40 |
1650|1640 | HASH JOIN ANTI | | 127 | 18288 | | 11M (27)| 39:30:37 |
1651|1641 | NESTED LOOPS | | 127 | 15494 | | 271 (3)| 00:00:04 |
1652|1642 | TABLE ACCESS FULL | PO_INVOICE | 127 | 10668 | | 220 (3)| 00:00:03 |
1653|1643 | TABLE ACCESS BY INDEX ROWID | BD_CUBASDOC | 1 | 38 | | 1 (0)| 00:00:01 |
1654|1644 | INDEX UNIQUE SCAN | PK_BD_CUBASDOC | 1 | | | 1 (0)| 00:00:01 |
1655|1645 | VIEW | | 52G| 1079G| | 10M (16)| 34:23:30 |
1656|1646 | UNION-ALL | | | | | | |
1657|1647 | HASH JOIN RIGHT OUTER | | 52G| 31T| 202M| 9172K (18)| 30:34:32 |
1658|1648 | VIEW | | 1251K| 188M| | 74342 (3)| 00:14:53 |
1659|1649 | HASH GROUP BY | | 1251K| 177M| 407M| 74342 (3)| 00:14:53 |
1660|1650 | HASH JOIN | | 1251K| 177M| | 32704 (4)| 00:06:33 |
1661|1651 | TABLE ACCESS BY INDEX ROWID | AR