ITPub博客

整型序号产生器(八)

原创 Linux操作系统 作者:guoge 时间:2007-12-14 17:02:16 0 删除 编辑

性能比较 小数字

下面的表显示了各种方法在产生少量连续整数的性能比较。

统计

 

 
 

                                             Integer                                                                                                              Integer                    ROWNUM   CONNECT BY                      Type     Type Constructor   Pipelined

METRIC_NAME                                     Table        MODEL  + Big Table        LEVEL         CUBE  Constructor + Cartesian Product     Function

---------------------------------------- ------------ ------------ ------------ ------------ ------------ ------------ ------------------- ------------

Elapsed Time (1/100 sec)                            3            3            3            2            5          262                   3            4

session pga memory max                        262,144      262,144      262,144      262,144      262,144      262,144             262,144      327,680

session pga memory                            196,608       65,536      131,072      131,072      196,608       65,536             131,072      327,680

redo size                                       2,744        2,640        2,684        2,684        2,684        2,684               2,684        2,684

sorts (rows)                                    2,071        2,071        2,071        2,072        2,199        2,071               2,081        2,076

session uga memory                                  0            0            0            0            0       65,464              65,464       65,464

 

 

Latch Gets

 

                                             Integer                    ROWNUM   CONNECT BY                      Type     Type Constructor   Pipelined

METRIC_NAME                                     Table        MODEL  + Big Table        LEVEL         CUBE  Constructor + Cartesian Product     Function

---------------------------------------- ------------ ------------ ------------ ------------ ------------ ------------ ------------------- ------------

cache buffers chains                              206          163          221          163          163        1,208                 181          249

row cache objects                                 136           96          129           87           84          135                 114          171

library cache                                      92           77           86           80           77          113                  89          179

shared pool                                        70           25           26           24           25           85                  29           45

session idle bit                                   56           55           56           55           55           56                  55           57

library cache pin                                  50           43           48           43           43           57                  45           89

library cache lock                                 26           20           28           20           20           40                  25           72

enqueues                                           23           16           17           16           16           26                  16           20

enqueue hash chains                                22           16           16           16           16           26                  16           18

shared pool simulator                              12            9            7            9            9           16                  10           17

object queue header operation                       8           12           12           12           12          305                  12           15

redo allocation                                     8            8            8            8            8           18                   8            8

cache buffers lru chain                             7            6            6            6            6          396                   6            7

SQL memory manager workarea list latch              6           10            6            6            6           73                   6            6

session allocation                                  6            2            4            3            2            2                   2            6

sort extent pool                                    4            4            4            4            4            4                   4            4

session switching                                   4            4            4            4            4            4                   4            4

kks stats                                           4            2            2            2            2            4                   2            2

simulator hash latch                                4            0           10            0            0          134                   0            1

simulator lru latch                                 4            0           10            0            0          130                   0            1

PL/SQL warning settings                             3            3            3            3            3            3                   3            3

compile environment latch                           2            1            2            1            1            1                   1            3

object stats modification                           1            1            2            1            1            1                   1            2

library cache lock allocation                       1            1            1            1            1            1                   1            2

dml lock allocation                                 1            1            1            1            1            1                   1            1

FOB s.o list latch                                  1            0            0            1            0            0                   0            1

OS process                                          0            0            0            3            0            0                   0            0

messages                                            0            0            0            1            0           40                   0            0

channel operations parent latch                     0            0            0            1            0           18                   0            0

channel handle pool latch                           0            0            0            1            0            0                   0            0

OS process allocation                               0            0            0            1            0            0                   0            0

process allocation                                  0            0            0            1            0            0                   0            0

process group creation                              0            0            0            1            0            0                   0            0

checkpoint queue latch                              0            0            0            0            0          269                   0            0

redo writing                                        0            0            0            0            0           13                   0            0

active checkpoint queue latch                       0            0            0            0            0           13                   0            0

loader state object freelist                        0            0            0            0            0           12                   0            0

virtual circuit buffers                             0            0            0            0            0            9                   0            0

virtual circuit queues                              0            0            0            0            0            7                   0            0

parallel query alloc buffer                         0            0            0            0            0            4                   0            0

user lock                                           0            0            0            0            0            4                   0            0

session timer                                       0            0            0            0            0            3                   0            0

library cache load lock                             0            0            0            0            0            2                   0       

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

请登录后发表评论 登录
全部评论

注册时间:2007-12-12

  • 博文量
    72
  • 访问量
    208501