10032 10033 跟踪文件学习

*** 2008-09-25 17:03:15.702
*** SERVICE NAME:(SYS$USERS) 2008-09-25 17:03:15.702
*** SESSION ID:(146.30) 2008-09-25 17:03:15.702
Recording run at 400989 for 5 blocks
Recording run at 40098f for 5 blocks
Recording run at 400994 for 5 blocks
Recording run at 400999 for 5 blocks
.....................
.....................
--第一遍生成上面的归并段到temp空间
--下面开始读这些归并段，生成更大的归并段
---因为一次只能读3个（max intermediate merge width）
---- Sort Parameters ------------------------------
sort_area_size                    65536
sort_area_retained_size           65536
sort_multiblock_read_count        1
max intermediate merge width      3
Merging run at 40030d for 5 blocks
Merging run at 400312 for 5 blocks
Merging run at 400317 for 5 blocks
Total number of blocks to read: 15 blocks
Recording run at 40040f for 15 blocks
Merging run at 40031c for 5 blocks
Merging run at 400321 for 5 blocks
Merging run at 400326 for 5 blocks
Total number of blocks to read: 15 blocks
Recording run at 40041e for 15 blocks
Merging run at 40032b for 5 blocks
Merging run at 400330 for 5 blocks
Merging run at 400359 for 5 blocks
Total number of blocks to read: 15 blocks
Recording run at 40042d for 15 blocks
....................
...................
-----------------开始进行第二次归并
Merging run at 40032f for 16 blocks
Merging run at 40033f for 16 blocks
Merging run at 40034f for 16 blocks
Total number of blocks to read: 48 blocks
Recording run at 400a52 for 46 blocks
Merging run at 40035f for 16 blocks
Merging run at 40036f for 16 blocks
Merging run at 40037f for 16 blocks
Total number of blocks to read: 48 blocks
Recording run at 400dc0 for 46 blocks
....................
------开始进行第3次归并
Merging run at 4003aa for 46 blocks
Merging run at 4003d8 for 46 blocks
Merging run at 400406 for 45 blocks
Total number of blocks to read: 137 blocks
Recording run at 400c75 for 136 blocks
Merging run at 400843 for 45 blocks
Merging run at 40087a for 44 blocks
Merging run at 400890 for 46 blocks
Total number of blocks to read: 135 blocks
Recording run at 40038d for 133 blocks
....................

------开始进行第4次归并
Merging run at 4009a0 for 135 blocks
Merging run at 4009c7 for 136 blocks
Merging run at 400ac3 for 130 blocks
Total number of blocks to read: 401 blocks
Recording run at 40089c for 400 blocks
Merging run at 400aff for 135 blocks
Merging run at 400bb6 for 134 blocks
Merging run at 400bdc for 132 blocks
Total number of blocks to read: 401 blocks
*** 2008-09-25 17:03:25.843
Recording run at 400aec for 400 blocks
Merging run at 400c20 for 133 blocks
Merging run at 400c75 for 136 blocks
Merging run at 400cf5 for 132 blocks
Total number of blocks to read: 401 blocks
Recording run at 400bcc for 400 blocks
....................

--------开始进行第5次归并
Merging run at 40089c for 400 blocks
Merging run at 400aec for 400 blocks
Merging run at 400bcc for 400 blocks
Merging run at 400d09 for 403 blocks
Total number of blocks to read: 1603 blocks
....................

---- Sort Statistics ------------------------------
Initial runs                              322  ---第一次生成的归并段数
Intermediate runs                         159  ---其后生成的归并段数
Number of merges                          160  --- 执行的归并次数
Input records                             348294 ---输入行数
Output records                            348294 ---输出行数
Disk blocks 1st pass                      1797   ---第一次生成的归并段总块数
Total disk blocks used                    2304
Total number of comparisons performed     3430042 ---比较的次数
  Comparisons performed by in-memory sort 692244  ---内部排序期间的比较次数
  Comparisons performed during merge      2737476 ---从磁盘上归并期间的排序次数
  Comparisons while searching for key in-memory 322
Temp segments allocated                   1       ---使用的临时段
Extents allocated                         18      ---临时段区间扩张次数
Uses version 2 sort
Uses asynchronous IO
    ---- Run Directory Statistics ----
Run directory block reads (buffer cache)  641
Block pins (for run directory)            1
Block repins (for run directory)          640
    ---- Direct Write Statistics -----
Write slot size                           8192
Write slots used during in-memory sort    2
Number of direct writes                   8290   ----向临时段写的块数，他等于多有生成的归并段块数总和
Num blocks written (with direct write)    8290
Block pins (for sort records)             8290
Cached block repins (for sort records)    1
Waits for async writes                    4894
    ---- Direct Read Statistics ------
Size of read slots for merge phase        8192
Number of read slots for merge phase      6
Size of read slots for output             8192
Number of read slots for output           8
Number of direct sync reads               4150 ---读的块数
Number of blocks read synchronously       4150
Number of direct async reads              4140 ---读的块数
Number of blocks read asynchronously      4140
Waits for async reads                     2475
---- End of Sort Statistics -----------------------
*** SESSION ID:(146.30) 2008-09-25 17:03:32.093
---- Sort Parameters ------------------------------
sort_area_size                    65536
sort_area_retained_size           65536
sort_multiblock_read_count        1
max intermediate merge width      3
---- Sort Statistics ------------------------------
Input records                             3
Output records                            3
Total number of comparisons performed     2
  Comparisons performed by in-memory sort 2
Total amount of memory used               8192
Uses version 1 sort
Does not use asynchronous IO
---- End of Sort Statistics -----------------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/69265/viewspace-464359/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/69265/viewspace-464359/