-
Notifications
You must be signed in to change notification settings - Fork 849
/
Copy pathtest3.lst
708 lines (662 loc) · 31.9 KB
/
test3.lst
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
SQL> @test3
SQL> set timing on
SQL> set linesize 1000
SQL> set pagesize 100
SQL> set trims on
SQL>
SQL> --
SQL> -- We are going to perform a partition exchange load and
SQL> -- take a look at the timings for HyperLogLog synopses.
SQL> --
SQL> exec dbms_stats.set_table_prefs(null,'t1','incremental_staleness', 'NULL')
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
SQL>
SQL> exec DBMS_STATS.SET_TABLE_PREFS (null,'exch','INCREMENTAL_LEVEL','table');
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
SQL> exec dbms_stats.set_table_prefs(null,'exch', 'approximate_ndv_algorithm', 'hyperloglog')
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
SQL> exec dbms_stats.delete_table_stats(null,'exch')
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
SQL> exec dbms_stats.gather_table_stats(null,'exch');
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.69
SQL>
SQL> --
SQL> -- The exchange table has synopses
SQL> --
SQL> select count(*) from sys.WRI$_OPTSTAT_SYNOPSIS$
2 where bo# = (select object_id from user_objects where object_name = 'EXCH' and object_type = 'TABLE');
COUNT(*)
----------
0
Elapsed: 00:00:00.03
SQL>
SQL> --
SQL> -- The exchange table has 5 columns...
SQL> --
SQL> select count(*) from sys.WRI$_OPTSTAT_SYNOPSIS_HEAD$
2 where bo# = (select object_id from user_objects where object_name = 'EXCH' and object_type = 'TABLE');
COUNT(*)
----------
5
Elapsed: 00:00:00.01
SQL>
SQL> select spare1,spare2 from sys.WRI$_OPTSTAT_SYNOPSIS_HEAD$
2 where bo# = (select object_id from user_objects where object_name = 'EXCH' and object_type = 'TABLE')
3 and rownum<11;
SPARE1 SPARE2
---------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------
1 0D0C0000100000000000000ED1542081CB2092092881CA2CA20920820924624924A24920A24A20B2491C93482472C624D2482CA30A2CA20D1C91C91C920A34934C24720B28E28924C30B2891CA289287
1 0D0C08E900010000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
1 0D0C00010E6900000000000027420020410C10C01051010840840010C00401C20030810020431410C50800C01001000C20C20430C10480821830851410C20C21010830811430C51030010C3042100044
1 0D0C00001000000000000001882D2441C61442861031C50C414910A1C81452841861091091481C31481C41460C81071441851472481C71871840CF1C41041471C51051871063051051C51091C4106184
1 0D0C058600050000000000000005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Elapsed: 00:00:00.02
SQL>
SQL> pause
SQL>
SQL> --
SQL> -- Get stats up to date on our main table, T1
SQL> --
SQL> exec dbms_stats.set_table_prefs(null,'t1', 'approximate_ndv_algorithm', 'hyperloglog')
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
SQL> exec dbms_stats.delete_table_stats(null,'t1')
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.56
SQL> exec dbms_stats.gather_table_stats(null,'t1')
PL/SQL procedure successfully completed.
Elapsed: 00:00:06.47
SQL>
SQL> pause
SQL>
SQL> --
SQL> -- Perform the exchange - we expect it to be very fast
SQL> --
SQL> alter table t1 exchange partition p1 with table exch;
Table altered.
Elapsed: 00:00:00.22
SQL>
SQL> pause
SQL>
SQL> --
SQL> -- Gather stats to refresh the global-level table stats
SQL> -- We expect this to be very fast because the synopsis is used
SQL> --
SQL> exec dbms_stats.gather_table_stats(null,'t1')
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.11
SQL>
SQL> pause
SQL>
SQL> --
SQL> -- Confirm we have HyperLogLog synopses...
SQL> --
SQL> @look
SQL> column partition_name format a40
SQL> column synopsis_type format a40
SQL> set pagesize 1000
SQL> set linesize 500
SQL> set trims on
SQL> set tab off
SQL>
SQL> select subobject_name partition_name,
2 decode(h.spare1,NULL,'ADAPTIVE SAMPLING','HYPERLOGLOG') synopsis_type
3 from dba_objects o,
4 sys.wri$_optstat_synopsis_head$ h
5 where o.object_type = 'TABLE PARTITION'
6 and o.object_name = 'T1'
7 and o.owner = USER
8 and h.group# = o.object_id*2
9 and intcol# = 1
10 order by partition_name;
PARTITION_NAME SYNOPSIS_TYPE
---------------------------------------- ----------------------------------------
P1 HYPERLOGLOG
P2 HYPERLOGLOG
SYS_P16732 HYPERLOGLOG
SYS_P16733 HYPERLOGLOG
SYS_P16734 HYPERLOGLOG
SYS_P16735 HYPERLOGLOG
SYS_P16736 HYPERLOGLOG
SYS_P16737 HYPERLOGLOG
SYS_P16738 HYPERLOGLOG
SYS_P16739 HYPERLOGLOG
SYS_P16740 HYPERLOGLOG
SYS_P16741 HYPERLOGLOG
SYS_P16742 HYPERLOGLOG
SYS_P16743 HYPERLOGLOG
SYS_P16744 HYPERLOGLOG
SYS_P16745 HYPERLOGLOG
SYS_P16746 HYPERLOGLOG
SYS_P16747 HYPERLOGLOG
SYS_P16748 HYPERLOGLOG
SYS_P16749 HYPERLOGLOG
SYS_P16750 HYPERLOGLOG
SYS_P16751 HYPERLOGLOG
SYS_P16752 HYPERLOGLOG
SYS_P16753 HYPERLOGLOG
SYS_P16754 HYPERLOGLOG
SYS_P16755 HYPERLOGLOG
SYS_P16756 HYPERLOGLOG
SYS_P16757 HYPERLOGLOG
SYS_P16758 HYPERLOGLOG
SYS_P16759 HYPERLOGLOG
SYS_P16760 HYPERLOGLOG
SYS_P16761 HYPERLOGLOG
SYS_P16762 HYPERLOGLOG
SYS_P16763 HYPERLOGLOG
SYS_P16764 HYPERLOGLOG
SYS_P16765 HYPERLOGLOG
SYS_P16766 HYPERLOGLOG
SYS_P16767 HYPERLOGLOG
SYS_P16768 HYPERLOGLOG
SYS_P16769 HYPERLOGLOG
SYS_P16770 HYPERLOGLOG
SYS_P16771 HYPERLOGLOG
SYS_P16772 HYPERLOGLOG
SYS_P16773 HYPERLOGLOG
SYS_P16774 HYPERLOGLOG
SYS_P16775 HYPERLOGLOG
SYS_P16776 HYPERLOGLOG
SYS_P16777 HYPERLOGLOG
SYS_P16778 HYPERLOGLOG
SYS_P16779 HYPERLOGLOG
SYS_P16780 HYPERLOGLOG
SYS_P16781 HYPERLOGLOG
SYS_P16782 HYPERLOGLOG
SYS_P16783 HYPERLOGLOG
SYS_P16784 HYPERLOGLOG
SYS_P16785 HYPERLOGLOG
SYS_P16786 HYPERLOGLOG
SYS_P16787 HYPERLOGLOG
SYS_P16788 HYPERLOGLOG
SYS_P16789 HYPERLOGLOG
SYS_P16790 HYPERLOGLOG
SYS_P16791 HYPERLOGLOG
SYS_P16792 HYPERLOGLOG
SYS_P16793 HYPERLOGLOG
SYS_P16794 HYPERLOGLOG
SYS_P16795 HYPERLOGLOG
SYS_P16796 HYPERLOGLOG
SYS_P16797 HYPERLOGLOG
SYS_P16798 HYPERLOGLOG
SYS_P16799 HYPERLOGLOG
SYS_P16800 HYPERLOGLOG
SYS_P16801 HYPERLOGLOG
SYS_P16802 HYPERLOGLOG
SYS_P16803 HYPERLOGLOG
SYS_P16804 HYPERLOGLOG
SYS_P16805 HYPERLOGLOG
SYS_P16806 HYPERLOGLOG
SYS_P16807 HYPERLOGLOG
SYS_P16808 HYPERLOGLOG
SYS_P16809 HYPERLOGLOG
SYS_P16810 HYPERLOGLOG
SYS_P16811 HYPERLOGLOG
SYS_P16812 HYPERLOGLOG
SYS_P16813 HYPERLOGLOG
SYS_P16814 HYPERLOGLOG
SYS_P16815 HYPERLOGLOG
SYS_P16816 HYPERLOGLOG
SYS_P16817 HYPERLOGLOG
SYS_P16818 HYPERLOGLOG
SYS_P16819 HYPERLOGLOG
SYS_P16820 HYPERLOGLOG
SYS_P16821 HYPERLOGLOG
SYS_P16822 HYPERLOGLOG
SYS_P16823 HYPERLOGLOG
SYS_P16824 HYPERLOGLOG
SYS_P16825 HYPERLOGLOG
SYS_P16826 HYPERLOGLOG
SYS_P16827 HYPERLOGLOG
SYS_P16828 HYPERLOGLOG
SYS_P16829 HYPERLOGLOG
SYS_P16830 HYPERLOGLOG
SYS_P16831 HYPERLOGLOG
SYS_P16832 HYPERLOGLOG
SYS_P16833 HYPERLOGLOG
SYS_P16834 HYPERLOGLOG
SYS_P16835 HYPERLOGLOG
SYS_P16836 HYPERLOGLOG
SYS_P16837 HYPERLOGLOG
SYS_P16838 HYPERLOGLOG
SYS_P16839 HYPERLOGLOG
SYS_P16840 HYPERLOGLOG
SYS_P16841 HYPERLOGLOG
SYS_P16842 HYPERLOGLOG
SYS_P16843 HYPERLOGLOG
SYS_P16844 HYPERLOGLOG
SYS_P16845 HYPERLOGLOG
SYS_P16846 HYPERLOGLOG
SYS_P16847 HYPERLOGLOG
SYS_P16848 HYPERLOGLOG
SYS_P16849 HYPERLOGLOG
SYS_P16850 HYPERLOGLOG
SYS_P16851 HYPERLOGLOG
SYS_P16852 HYPERLOGLOG
SYS_P16853 HYPERLOGLOG
SYS_P16854 HYPERLOGLOG
SYS_P16855 HYPERLOGLOG
SYS_P16856 HYPERLOGLOG
SYS_P16857 HYPERLOGLOG
SYS_P16858 HYPERLOGLOG
SYS_P16859 HYPERLOGLOG
SYS_P16860 HYPERLOGLOG
SYS_P16861 HYPERLOGLOG
SYS_P16862 HYPERLOGLOG
SYS_P16863 HYPERLOGLOG
SYS_P16864 HYPERLOGLOG
SYS_P16865 HYPERLOGLOG
SYS_P16866 HYPERLOGLOG
SYS_P16867 HYPERLOGLOG
SYS_P16868 HYPERLOGLOG
SYS_P16869 HYPERLOGLOG
SYS_P16870 HYPERLOGLOG
SYS_P16871 HYPERLOGLOG
SYS_P16872 HYPERLOGLOG
SYS_P16873 HYPERLOGLOG
SYS_P16874 HYPERLOGLOG
SYS_P16875 HYPERLOGLOG
SYS_P16876 HYPERLOGLOG
SYS_P16877 HYPERLOGLOG
SYS_P16878 HYPERLOGLOG
SYS_P16879 HYPERLOGLOG
SYS_P16880 HYPERLOGLOG
SYS_P16881 HYPERLOGLOG
SYS_P16882 HYPERLOGLOG
SYS_P16883 HYPERLOGLOG
SYS_P16884 HYPERLOGLOG
SYS_P16885 HYPERLOGLOG
SYS_P16886 HYPERLOGLOG
SYS_P16887 HYPERLOGLOG
SYS_P16888 HYPERLOGLOG
SYS_P16889 HYPERLOGLOG
SYS_P16890 HYPERLOGLOG
SYS_P16891 HYPERLOGLOG
SYS_P16892 HYPERLOGLOG
SYS_P16893 HYPERLOGLOG
SYS_P16894 HYPERLOGLOG
SYS_P16895 HYPERLOGLOG
SYS_P16896 HYPERLOGLOG
SYS_P16897 HYPERLOGLOG
SYS_P16898 HYPERLOGLOG
SYS_P16899 HYPERLOGLOG
SYS_P16900 HYPERLOGLOG
SYS_P16901 HYPERLOGLOG
SYS_P16902 HYPERLOGLOG
SYS_P16903 HYPERLOGLOG
SYS_P16904 HYPERLOGLOG
SYS_P16905 HYPERLOGLOG
SYS_P16906 HYPERLOGLOG
SYS_P16907 HYPERLOGLOG
SYS_P16908 HYPERLOGLOG
SYS_P16909 HYPERLOGLOG
SYS_P16910 HYPERLOGLOG
SYS_P16911 HYPERLOGLOG
SYS_P16912 HYPERLOGLOG
SYS_P16913 HYPERLOGLOG
SYS_P16914 HYPERLOGLOG
SYS_P16915 HYPERLOGLOG
SYS_P16916 HYPERLOGLOG
SYS_P16917 HYPERLOGLOG
SYS_P16918 HYPERLOGLOG
SYS_P16919 HYPERLOGLOG
SYS_P16920 HYPERLOGLOG
SYS_P16921 HYPERLOGLOG
SYS_P16922 HYPERLOGLOG
SYS_P16923 HYPERLOGLOG
SYS_P16924 HYPERLOGLOG
SYS_P16925 HYPERLOGLOG
SYS_P16926 HYPERLOGLOG
SYS_P16927 HYPERLOGLOG
SYS_P16928 HYPERLOGLOG
SYS_P16929 HYPERLOGLOG
SYS_P16930 HYPERLOGLOG
SYS_P16931 HYPERLOGLOG
SYS_P16932 HYPERLOGLOG
SYS_P16933 HYPERLOGLOG
SYS_P16934 HYPERLOGLOG
SYS_P16935 HYPERLOGLOG
SYS_P16936 HYPERLOGLOG
SYS_P16937 HYPERLOGLOG
SYS_P16938 HYPERLOGLOG
SYS_P16939 HYPERLOGLOG
SYS_P16940 HYPERLOGLOG
SYS_P16941 HYPERLOGLOG
SYS_P16942 HYPERLOGLOG
SYS_P16943 HYPERLOGLOG
SYS_P16944 HYPERLOGLOG
SYS_P16945 HYPERLOGLOG
SYS_P16946 HYPERLOGLOG
SYS_P16947 HYPERLOGLOG
SYS_P16948 HYPERLOGLOG
SYS_P16949 HYPERLOGLOG
SYS_P16950 HYPERLOGLOG
SYS_P16951 HYPERLOGLOG
SYS_P16952 HYPERLOGLOG
SYS_P16953 HYPERLOGLOG
SYS_P16954 HYPERLOGLOG
SYS_P16955 HYPERLOGLOG
SYS_P16956 HYPERLOGLOG
SYS_P16957 HYPERLOGLOG
SYS_P16958 HYPERLOGLOG
SYS_P16959 HYPERLOGLOG
SYS_P16960 HYPERLOGLOG
SYS_P16961 HYPERLOGLOG
SYS_P16962 HYPERLOGLOG
SYS_P16963 HYPERLOGLOG
SYS_P16964 HYPERLOGLOG
SYS_P16965 HYPERLOGLOG
SYS_P16966 HYPERLOGLOG
SYS_P16967 HYPERLOGLOG
SYS_P16968 HYPERLOGLOG
SYS_P16969 HYPERLOGLOG
SYS_P16970 HYPERLOGLOG
SYS_P16971 HYPERLOGLOG
SYS_P16972 HYPERLOGLOG
SYS_P16973 HYPERLOGLOG
SYS_P16974 HYPERLOGLOG
SYS_P16975 HYPERLOGLOG
SYS_P16976 HYPERLOGLOG
SYS_P16977 HYPERLOGLOG
SYS_P16978 HYPERLOGLOG
SYS_P16979 HYPERLOGLOG
SYS_P16980 HYPERLOGLOG
SYS_P16981 HYPERLOGLOG
SYS_P16982 HYPERLOGLOG
SYS_P16983 HYPERLOGLOG
SYS_P16984 HYPERLOGLOG
SYS_P16985 HYPERLOGLOG
SYS_P16986 HYPERLOGLOG
SYS_P16987 HYPERLOGLOG
SYS_P16988 HYPERLOGLOG
SYS_P16989 HYPERLOGLOG
SYS_P16990 HYPERLOGLOG
SYS_P16991 HYPERLOGLOG
SYS_P16992 HYPERLOGLOG
SYS_P16993 HYPERLOGLOG
SYS_P16994 HYPERLOGLOG
SYS_P16995 HYPERLOGLOG
SYS_P16996 HYPERLOGLOG
SYS_P16997 HYPERLOGLOG
SYS_P16998 HYPERLOGLOG
SYS_P16999 HYPERLOGLOG
SYS_P17000 HYPERLOGLOG
SYS_P17001 HYPERLOGLOG
SYS_P17002 HYPERLOGLOG
SYS_P17003 HYPERLOGLOG
SYS_P17004 HYPERLOGLOG
SYS_P17005 HYPERLOGLOG
SYS_P17006 HYPERLOGLOG
SYS_P17007 HYPERLOGLOG
SYS_P17008 HYPERLOGLOG
SYS_P17009 HYPERLOGLOG
SYS_P17010 HYPERLOGLOG
SYS_P17011 HYPERLOGLOG
SYS_P17012 HYPERLOGLOG
SYS_P17013 HYPERLOGLOG
SYS_P17014 HYPERLOGLOG
SYS_P17015 HYPERLOGLOG
SYS_P17016 HYPERLOGLOG
SYS_P17017 HYPERLOGLOG
SYS_P17018 HYPERLOGLOG
SYS_P17019 HYPERLOGLOG
SYS_P17020 HYPERLOGLOG
SYS_P17021 HYPERLOGLOG
SYS_P17022 HYPERLOGLOG
SYS_P17023 HYPERLOGLOG
SYS_P17024 HYPERLOGLOG
SYS_P17025 HYPERLOGLOG
SYS_P17026 HYPERLOGLOG
SYS_P17027 HYPERLOGLOG
SYS_P17028 HYPERLOGLOG
SYS_P17029 HYPERLOGLOG
SYS_P17030 HYPERLOGLOG
SYS_P17031 HYPERLOGLOG
SYS_P17032 HYPERLOGLOG
SYS_P17033 HYPERLOGLOG
SYS_P17034 HYPERLOGLOG
SYS_P17035 HYPERLOGLOG
SYS_P17036 HYPERLOGLOG
SYS_P17037 HYPERLOGLOG
SYS_P17038 HYPERLOGLOG
SYS_P17039 HYPERLOGLOG
SYS_P17040 HYPERLOGLOG
SYS_P17041 HYPERLOGLOG
SYS_P17042 HYPERLOGLOG
SYS_P17043 HYPERLOGLOG
SYS_P17044 HYPERLOGLOG
SYS_P17045 HYPERLOGLOG
SYS_P17046 HYPERLOGLOG
SYS_P17047 HYPERLOGLOG
SYS_P17048 HYPERLOGLOG
SYS_P17049 HYPERLOGLOG
SYS_P17050 HYPERLOGLOG
SYS_P17051 HYPERLOGLOG
SYS_P17052 HYPERLOGLOG
SYS_P17053 HYPERLOGLOG
SYS_P17054 HYPERLOGLOG
SYS_P17055 HYPERLOGLOG
SYS_P17056 HYPERLOGLOG
SYS_P17057 HYPERLOGLOG
SYS_P17058 HYPERLOGLOG
SYS_P17059 HYPERLOGLOG
SYS_P17060 HYPERLOGLOG
SYS_P17061 HYPERLOGLOG
SYS_P17062 HYPERLOGLOG
SYS_P17063 HYPERLOGLOG
SYS_P17064 HYPERLOGLOG
SYS_P17065 HYPERLOGLOG
SYS_P17066 HYPERLOGLOG
SYS_P17067 HYPERLOGLOG
SYS_P17068 HYPERLOGLOG
SYS_P17069 HYPERLOGLOG
SYS_P17070 HYPERLOGLOG
SYS_P17071 HYPERLOGLOG
SYS_P17072 HYPERLOGLOG
SYS_P17073 HYPERLOGLOG
SYS_P17074 HYPERLOGLOG
SYS_P17075 HYPERLOGLOG
SYS_P17076 HYPERLOGLOG
SYS_P17077 HYPERLOGLOG
SYS_P17078 HYPERLOGLOG
SYS_P17079 HYPERLOGLOG
SYS_P17080 HYPERLOGLOG
SYS_P17081 HYPERLOGLOG
SYS_P17082 HYPERLOGLOG
SYS_P17083 HYPERLOGLOG
SYS_P17084 HYPERLOGLOG
SYS_P17085 HYPERLOGLOG
SYS_P17086 HYPERLOGLOG
SYS_P17087 HYPERLOGLOG
SYS_P17088 HYPERLOGLOG
SYS_P17089 HYPERLOGLOG
SYS_P17090 HYPERLOGLOG
SYS_P17091 HYPERLOGLOG
SYS_P17092 HYPERLOGLOG
SYS_P17093 HYPERLOGLOG
SYS_P17094 HYPERLOGLOG
SYS_P17095 HYPERLOGLOG
SYS_P17096 HYPERLOGLOG
SYS_P17097 HYPERLOGLOG
SYS_P17098 HYPERLOGLOG
SYS_P17099 HYPERLOGLOG
SYS_P17100 HYPERLOGLOG
SYS_P17101 HYPERLOGLOG
SYS_P17102 HYPERLOGLOG
SYS_P17103 HYPERLOGLOG
SYS_P17104 HYPERLOGLOG
SYS_P17105 HYPERLOGLOG
SYS_P17106 HYPERLOGLOG
SYS_P17107 HYPERLOGLOG
SYS_P17108 HYPERLOGLOG
SYS_P17109 HYPERLOGLOG
SYS_P17110 HYPERLOGLOG
SYS_P17111 HYPERLOGLOG
SYS_P17112 HYPERLOGLOG
SYS_P17113 HYPERLOGLOG
SYS_P17114 HYPERLOGLOG
SYS_P17115 HYPERLOGLOG
SYS_P17116 HYPERLOGLOG
SYS_P17117 HYPERLOGLOG
SYS_P17118 HYPERLOGLOG
SYS_P17119 HYPERLOGLOG
SYS_P17120 HYPERLOGLOG
SYS_P17121 HYPERLOGLOG
SYS_P17122 HYPERLOGLOG
SYS_P17123 HYPERLOGLOG
SYS_P17124 HYPERLOGLOG
SYS_P17125 HYPERLOGLOG
SYS_P17126 HYPERLOGLOG
SYS_P17127 HYPERLOGLOG
SYS_P17128 HYPERLOGLOG
SYS_P17129 HYPERLOGLOG
SYS_P17130 HYPERLOGLOG
SYS_P17131 HYPERLOGLOG
SYS_P17132 HYPERLOGLOG
SYS_P17133 HYPERLOGLOG
SYS_P17134 HYPERLOGLOG
SYS_P17135 HYPERLOGLOG
SYS_P17136 HYPERLOGLOG
SYS_P17137 HYPERLOGLOG
SYS_P17138 HYPERLOGLOG
SYS_P17139 HYPERLOGLOG
SYS_P17140 HYPERLOGLOG
SYS_P17141 HYPERLOGLOG
SYS_P17142 HYPERLOGLOG
SYS_P17143 HYPERLOGLOG
SYS_P17144 HYPERLOGLOG
SYS_P17145 HYPERLOGLOG
SYS_P17146 HYPERLOGLOG
SYS_P17147 HYPERLOGLOG
SYS_P17148 HYPERLOGLOG
SYS_P17149 HYPERLOGLOG
SYS_P17150 HYPERLOGLOG
SYS_P17151 HYPERLOGLOG
SYS_P17152 HYPERLOGLOG
SYS_P17153 HYPERLOGLOG
SYS_P17154 HYPERLOGLOG
SYS_P17155 HYPERLOGLOG
SYS_P17156 HYPERLOGLOG
SYS_P17157 HYPERLOGLOG
SYS_P17158 HYPERLOGLOG
SYS_P17159 HYPERLOGLOG
SYS_P17160 HYPERLOGLOG
SYS_P17161 HYPERLOGLOG
SYS_P17162 HYPERLOGLOG
SYS_P17163 HYPERLOGLOG
SYS_P17164 HYPERLOGLOG
SYS_P17165 HYPERLOGLOG
SYS_P17166 HYPERLOGLOG
SYS_P17167 HYPERLOGLOG
SYS_P17168 HYPERLOGLOG
SYS_P17169 HYPERLOGLOG
SYS_P17170 HYPERLOGLOG
SYS_P17171 HYPERLOGLOG
SYS_P17172 HYPERLOGLOG
SYS_P17173 HYPERLOGLOG
SYS_P17174 HYPERLOGLOG
SYS_P17175 HYPERLOGLOG
SYS_P17176 HYPERLOGLOG
SYS_P17177 HYPERLOGLOG
SYS_P17178 HYPERLOGLOG
SYS_P17179 HYPERLOGLOG
SYS_P17180 HYPERLOGLOG
SYS_P17181 HYPERLOGLOG
SYS_P17182 HYPERLOGLOG
SYS_P17183 HYPERLOGLOG
SYS_P17184 HYPERLOGLOG
SYS_P17185 HYPERLOGLOG
SYS_P17186 HYPERLOGLOG
SYS_P17187 HYPERLOGLOG
SYS_P17188 HYPERLOGLOG
SYS_P17189 HYPERLOGLOG
SYS_P17190 HYPERLOGLOG
SYS_P17191 HYPERLOGLOG
SYS_P17192 HYPERLOGLOG
SYS_P17193 HYPERLOGLOG
SYS_P17194 HYPERLOGLOG
SYS_P17195 HYPERLOGLOG
SYS_P17196 HYPERLOGLOG
SYS_P17197 HYPERLOGLOG
SYS_P17198 HYPERLOGLOG
SYS_P17199 HYPERLOGLOG
SYS_P17200 HYPERLOGLOG
SYS_P17201 HYPERLOGLOG
SYS_P17202 HYPERLOGLOG
SYS_P17203 HYPERLOGLOG
SYS_P17204 HYPERLOGLOG
SYS_P17205 HYPERLOGLOG
SYS_P17206 HYPERLOGLOG
SYS_P17207 HYPERLOGLOG
SYS_P17208 HYPERLOGLOG
SYS_P17209 HYPERLOGLOG
SYS_P17210 HYPERLOGLOG
SYS_P17211 HYPERLOGLOG
SYS_P17212 HYPERLOGLOG
SYS_P17213 HYPERLOGLOG
SYS_P17214 HYPERLOGLOG
SYS_P17215 HYPERLOGLOG
SYS_P17216 HYPERLOGLOG
SYS_P17217 HYPERLOGLOG
SYS_P17218 HYPERLOGLOG
SYS_P17219 HYPERLOGLOG
SYS_P17220 HYPERLOGLOG
SYS_P17221 HYPERLOGLOG
SYS_P17222 HYPERLOGLOG
SYS_P17223 HYPERLOGLOG
SYS_P17224 HYPERLOGLOG
SYS_P17225 HYPERLOGLOG
SYS_P17226 HYPERLOGLOG
SYS_P17227 HYPERLOGLOG
SYS_P17228 HYPERLOGLOG
SYS_P17229 HYPERLOGLOG
SYS_P17230 HYPERLOGLOG
SYS_P17231 HYPERLOGLOG
SYS_P17232 HYPERLOGLOG
SYS_P17233 HYPERLOGLOG
SYS_P17234 HYPERLOGLOG
SYS_P17235 HYPERLOGLOG
SYS_P17236 HYPERLOGLOG
SYS_P17237 HYPERLOGLOG
SYS_P17238 HYPERLOGLOG
SYS_P17239 HYPERLOGLOG
SYS_P17240 HYPERLOGLOG
SYS_P17241 HYPERLOGLOG
512 rows selected.
Elapsed: 00:00:00.03
SQL>
SQL> pause
SQL>
SQL> --
SQL> -- Note these timings for HYPERLOGLOG
SQL> -- Compare the timings with the next set of tests
SQL> --
SQL> alter table t1 exchange partition p1 with table exch;
Table altered.
Elapsed: 00:00:00.02
SQL> alter table t1 exchange partition p1 with table exch;
Table altered.
Elapsed: 00:00:00.18
SQL> alter table t1 exchange partition p1 with table exch;
Table altered.
Elapsed: 00:00:00.00
SQL> alter table t1 exchange partition p1 with table exch;
Table altered.
Elapsed: 00:00:00.26
SQL> --
SQL> -- This last exchange and gather stats returns the T1 to the state it
SQL> -- it was prior to the first exchange.
SQL> --
SQL> alter table t1 exchange partition p1 with table exch;
Table altered.
Elapsed: 00:00:00.01
SQL> exec dbms_stats.gather_table_stats(null,'t1')
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.10
SQL> exit