Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

2135

积分

484

好友

184

主题
发表于 2013-1-21 21:31:40 | 查看: 3150| 回复: 10
Oracle CBO 术语简写列表  optimizer CBO terms

cardinality (CDN)
Legend
CBQT - cost-based query transformation
JPPD - join predicate push-down
OJPPD - old-style (non-cost-based) JPPD
FPD - filter push-down
PM - predicate move-around
CVM - complex view merging
SPJ - select-project-join
SJC - set join conversion
SU - subquery unnesting
OBYE - order by elimination
OST - old style star transformation
ST - new (cbqt) star transformation
CNT - count(col) to count(*) transformation
JE - Join Elimination
JF - join factorization
SLP - select list pruning
DP - distinct placement
qb - query block
LB - leaf blocks
DK - distinct keys
LB/K - average number of leaf blocks per key
DB/K - average number of data blocks per key
CLUF - clustering factor
NDV - number of distinct values
Resp - response cost
Card - cardinality
Resc - resource cost
NL - nested loops (join)
SM - sort merge (join)
HA - hash (join)
CPUSPEED - CPU Speed
IOTFRSPEED - I/O transfer speed
IOSEEKTIM - I/O seek time
SREADTIM - average single block read time
MREADTIM - average multiblock read time
MBRC - average multiblock read count
MAXTHR - maximum I/O system throughput
SLAVETHR - average slave I/O throughput
dmeth - distribution method
  1: no partitioning required
  2: value partitioned
  4: right is random (round-robin)
  128: left is random (round-robin)
  8: broadcast right and partition left
  16: broadcast left and partition right
  32: partition left using partitioning of right
  64: partition right using partitioning of left
  256: run the join in serial
  0: invalid distribution method
sel - selectivity
ptn - partition
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/zh-hans/emergency-services

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569   
发表于 2013-1-21 21:46:23
好帖,赞一个

回复 显示全部楼层 道具 举报

发表于 2013-1-21 21:55:28
ML,太给力了!谢谢。

回复 显示全部楼层 道具 举报

发表于 2013-1-21 21:56:44
收藏,难得不要钱的

回复 显示全部楼层 道具 举报

发表于 2013-1-22 10:37:47
赞一个,谢谢分享!

回复 显示全部楼层 道具 举报

发表于 2013-1-22 13:48:42
这个需要复制粘贴,本地化。 哈哈

回复 显示全部楼层 道具 举报

发表于 2013-1-22 14:44:41
好贴,顶老大

回复 显示全部楼层 道具 举报

发表于 2013-1-25 12:28:09
好贴  像刘大学习

回复 显示全部楼层 道具 举报

发表于 2013-1-29 00:06:18
good、 好东西

回复 显示全部楼层 道具 举报

发表于 2013-3-3 22:43:51
好贴,收藏下

回复 显示全部楼层 道具 举报

发表于 2013-3-3 23:44:34
谢谢ML的分享以及抛玉引砖 ~

我简单补充一下,这个部分的缩写其实可以从Oracle的10053 trace文件中方便查到,如果看10053 trace 多了,应该就比较熟悉啦 :)
  1. [oracle@stonedb trace]$ sqlplus / as sysdba

  2. SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 3 23:20:52 2013

  3. Copyright (c) 1982, 2011, Oracle.  All rights reserved.


  4. Connected to:
  5. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
  6. With the Partitioning, OLAP, Data Mining and Real Application Testing options

  7. SQL> ALTER SESSION SET EVENTS '10053 trace name context forever, level 1';

  8. Session altered.

  9. SQL> select count(*) from dba_objects;

  10.   COUNT(*)
  11. ----------
  12.      74551

  13. SQL> ALTER SESSION SET EVENTS '10053 trace name context off';

  14. Session altered.

  15. SQL>
  16. SQL> !pwd
  17. /u01/app/oracle/diag/rdbms/stone11g/STONE11G/trace

  18. SQL> !ls -lrth | tail -2
  19. -rw-rw---- 1 oracle oinstall  71K Mar  3 23:22 STONE11G_ora_7155.trm
  20. -rw-rw---- 1 oracle oinstall 267K Mar  3 23:22 STONE11G_ora_7155.trc
复制代码
Legend位于10053 trace文件的大概位置:
  1. [oracle@stonedb trace]$ grep -i legend -A 52 STONE11G_ora_7155.trc
  2. Legend
  3. The following abbreviations are used by optimizer trace.
  4. CBQT - cost-based query transformation
  5. JPPD - join predicate push-down
  6. OJPPD - old-style (non-cost-based) JPPD
  7. FPD - filter push-down
  8. PM - predicate move-around
  9. CVM - complex view merging
  10. SPJ - select-project-join
  11. SJC - set join conversion
  12. SU - subquery unnesting
  13. OBYE - order by elimination
  14. OST - old style star transformation
  15. ST - new (cbqt) star transformation
  16. CNT - count(col) to count(*) transformation
  17. JE - Join Elimination
  18. JF - join factorization
  19. SLP - select list pruning
  20. DP - distinct placement
  21. qb - query block
  22. LB - leaf blocks
  23. DK - distinct keys
  24. LB/K - average number of leaf blocks per key
  25. DB/K - average number of data blocks per key
  26. CLUF - clustering factor
  27. NDV - number of distinct values
  28. Resp - response cost
  29. Card - cardinality
  30. Resc - resource cost
  31. NL - nested loops (join)
  32. SM - sort merge (join)
  33. HA - hash (join)
  34. CPUSPEED - CPU Speed
  35. IOTFRSPEED - I/O transfer speed
  36. IOSEEKTIM - I/O seek time
  37. SREADTIM - average single block read time
  38. MREADTIM - average multiblock read time
  39. MBRC - average multiblock read count
  40. MAXTHR - maximum I/O system throughput
  41. SLAVETHR - average slave I/O throughput
  42. dmeth - distribution method
  43.   1: no partitioning required
  44.   2: value partitioned
  45.   4: right is random (round-robin)
  46.   128: left is random (round-robin)
  47.   8: broadcast right and partition left
  48.   16: broadcast left and partition right
  49.   32: partition left using partitioning of right
  50.   64: partition right using partitioning of left
  51.   256: run the join in serial
  52.   0: invalid distribution method
  53. sel - selectivity
  54. ptn - partition
复制代码

回复 显示全部楼层 道具 举报

您需要登录后才可以回帖 登录 | 注册

扫码加入微信Oracle小密圈


QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站

GMT+8, 2017-6-23 21:37 , Processed in 0.093723 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569