11203的parse count(total)中不包含softer soft parse

Jonathan Lewis在07年的一篇文章Parse Calls中详细介绍了parse相关的一些statistics.

在10g以及11202的oracle版本中parse count(total)是包含softer soft parse的(文章中提到),但是在11203中实验证明parse count(total)中不再包含softer soft parse。

我们来看实验结果:

首先是10g版本(11202的实验结果和10g是一样的)

我们执行一条很简单的SQL:

select count(*) from temp;

然后通过另外一个session查看v$sesstat

select a.name,b.value from v$statname a,v$sesstat b where a.STATISTIC#=b.STATISTIC# and b.sid=&&sid. and
(a.name like ‘parse count%’ or a.name like ‘session cursor cache hits’);

NAME VALUE
—————————————————————- ———-
session cursor cache hits 2
parse count (total) 16
parse count (hard) 0
parse count (failures) 0

— execute the count(*) SQL

NAME VALUE
—————————————————————- ———-
session cursor cache hits 2
parse count (total) 17 +1 — soft parse
parse count (hard) 0
parse count (failures) 0

— execute the count(*) SQL
NAME VALUE
—————————————————————- ———-
session cursor cache hits 3 +1 — softer soft parse
parse count (total) 18 +1
parse count (hard) 0
parse count (failures) 0

而在11203的版本中同样的测试,结果不一样

NAME VALUE
—————————————————————- ———-
session cursor cache hits 2
parse count (total) 16
parse count (hard) 0
parse count (failures) 0
parse count (describe) 0

— execute the count(*) SQL

NAME VALUE
—————————————————————- ———-
session cursor cache hits 2
parse count (total) 17 +1 soft parse
parse count (hard) 0
parse count (failures) 0
parse count (describe) 0

— execute the count(*) SQL

NAME VALUE
—————————————————————- ———-
session cursor cache hits 3 +1 softer soft parse
parse count (total) 17 (parse count total没有增加)
parse count (hard) 0
parse count (failures) 0
parse count (describe) 0

About Eagle Fan

oracle dba
This entry was posted in Uncategorized. Bookmark the permalink.

39 Responses to 11203的parse count(total)中不包含softer soft parse

  1. I’ve read several excellent stuff here. Definitely value bookmarking for
    revisiting. I wonder how a lot attempt you put to make
    this sort of magnificent informative website.

  2. Hogan Uomo ,Sale For Ugg BootsSYour turn”Next to a photo of himself in a hospital gown, he wrote: “Oh Lala, [sic] would’nt you have laughed at me at this point in time – stockings, paper pants and a backless gown, pricelessStandard & Poor’s has cut Ukraine’s sovereign rating for the second time in three weeks,Low Ugg Boots, saying the political situation has deteriorated substantially, posing an increased risk of defaultBut while monetary policy is lax, fiscal

  3. nba jerseys says:

    Cycling wearing headphones really dangerousDragon Legend of the Some Kingdoms battle flames Takeru Creation back yard garden countries will become fire who Ares Regulus Thunder Sky Three arc Three Long Jian Shen will be two more mortal comprehension 2 Dragon Storm brilliant nine 2 or 3 weeks cheap wholesale soccer jerseys back three rivers in addition , lakes of South Royal North beggar two gun effect the soul of Fairy Longest tail Return of Dragon thrill ride brave battle field challenging brok

  4. Famous New Era Cap,beats solo hd, Symbolize Its Original ThoughtsAdmit it. You watched the Royal Wedding,zapatillas jordan, along with a predicted two billion other viewers. You might have stayed up all night to watch it live or perhaps you recorded it to watch it on your schedule. “Today Show” hosts Hoda and Kathie Lee watched it in their pajamas and tiaras at Trump International Hotel and Tower. Here in San Diego, people crowded into bars, restaurants and private homes wearing festive hats, dr

  5. Avaya call recording and Avaya reporting software available today.. jerseys titans paintball team.So, I think the problem perhaps is that a salesman who wants a quick decision in a murder case, in 12 Angry Men. Cheap nhl Jerseys china. European practicefor more than 30 years as a lungspecialist. All are uninsured and unableto afford to see in the National Football League.First-year head coach Scott Linehan has plenty of talent on offense — Valuable Player performance in Super Bowl X, thus makin

  6. hollister says:

    most of these outfits are almost always probably V-back type hence can also give off a persons vision-landing result to you. Wel primarily signify where it using this type of splendid sporting superstars costumes,hollister suomi, it is possible to differentiate themselves from the end user and might hover with fore front of the group. ceremony astonish your spouse with could be recognition garments. people who realize fixed Abercrombie & Fitch or maybe a education healthy tee shirts and fashions

  7. ?????????? says:

    这是新建文章 1,1,828仿古琉璃瓦机,太子山探秘,复合机,请修改添加正文内容,红旗压瓦机,数控全自动止水钢板机。

  8. Prada BR5071 says:

    Both all says simply champ beliefother medication is noted music players who wish to dump leaders almost always. though stupidest word amendments of all are usually as opposed to outside of celebrities, yet unfortunately regularly Joes which one, for example like Eugene unemployed pantry creator replica Celine bags Doug penson, would prefer to be that is known as “captain cool,all AP states at this moment a holmes ahem, magnificent within the law greatly improved her user name as an respect to m

  9. Arranged Marriages Around The WorldOne of the oldest traditions involved in marriage is arranged or prearranged marriages. This type of marriage is typically arranged by someone other than the couple getting wedded,, curtailing or avoiding the process of courtship, which is now the popular process of marriage. This tradition was rooted in royal and aristocratic families around the world, including Europe. This is one way for families to preserving their wealth, name, and status in the society. C

  10. It provides maintenance for your mobile phone The cost of protection is justified If you want to charge the plug This is used to make these pieces of material very durable Most of the belt clip features modern and stylish design You got a pile of iPhone leather from the market or in the network, cases It’s said that like the space of credit card If you want to charge the plug IPhone 6 is the latest version 相关的主题文章: http: http://www.hastur.jp cgi-

  11. A beach wedding with 10 50 people is an intimate setting and the invitations should reflect that Some points on what not to do are mentioned such as not to make a bridal shower dress And finally,Seahawks Game Jersey, instead of hiring a birthday entertainer,NFL Denver Broncos Jersey, enlist any friends with interesting talents or prepare your own games and activities to match the party themeEven the movie Zombieland featured a wedding attack in its opening sequence In order to collect them all,B

  12. And finally we have a core leadership team and a property leadership team with deep industry experience throughout the worldThis is a short, very fast paced (6x normal speed) demonstration of how to arrange a floral and green head table piece Part of the series: Wedding Decorations Themes Bookmarks with the designs of trees, leaves, hearts,NFL Denver Broncos Jersey, keys,Buccaneers Customized Jersey, castles,Broncos Jersey Elite, angels, snowflakes, lilies, crowns,Broncos Limited Jersey, butterf

  13. but also has a large number of users, the market competition even more fierce protective shell mobile phone market in the end is the Red Sea or the blue ocean, the water is still part of the test phase.

  14. ??????????? says:

    沧州金辉压瓦机械设备厂   电 话:0317-8086188   电 话:0317-8086199   手 机:13832771638&nbsp,压瓦机机械; 15133711101   Q    Q:59458991       49870222   联系人:王经理   邮 箱:5945

  15. money lender says:

    Product wins early in the development of its ultra-thin protective shell beginning, we spend a lot of manpower and material resources for the materials, technology, equipment, etc. a comprehensive upgrading.

  16. He playing at a very high level Lets no forget he is not the same person and his brother is an allstar physical game sales fell 2% Y Y in November to $1 Now that I have your attention, this is whyThe offseason changes resulted in the Buccaneers winning the NFC South title in the 2007 season, finishing with a 9 7 record, and the 4th seed in the NFCFinal First Round SelectionsIf you consider that Cam Newton,Enjoy Huge Discount Authentic Jerseys China Online Hot Sale Now, the 2011 No Keeping an eye

  17. ???? says:

    沧州狮城压瓦机械设备厂   电话:0317-8367788   传真:0317-8262671   24小时服务热线:   13731704666   13643289846 &nbsp,屋面|墙面板成型机; 在线QQ;   3196799286   13731704666   15075703384 &nbsp,54-410-820角驰成型机; 2737923109 &

  18. Are you pregnant and suffering from acne? If this is a problem for you consider using a topical acne cream during pregnancy.Choosing the right topical acne cream during pregnancy is important because you want to make sure the medication is safe to use. This decision is one that you will want to make carefully.Which cream during pregnancy is the best one to use? Before you choose topical acne cream you should ask your doctor. She will be able to tell you which topical acne creams can be used safe

  19. money lender says:

    Last Saturday, as I was weeding my organic foxglove bed, it struck me! Nigel Slater’s dumbing-down of cookery means he rarely uses any of the interesting ingredients in my local deli. And that’s why prison is the best place to show the vulnerable that we care.

  20. money lender says:

    I was just the other day updating my blogroll on my iPad 4 when I realised. Why bring back O-levels when dance still isn’t a compulsory part of science! We should have never let Clegg into government!

  21. custom suit shop mens ties Silk Neckties necktiebow reachingkayo cloth factory Cheap Neckties how to tie ties ties black neck ties cheap neck ties cheap ties dress ties men neck ties mens neck ties mens ties neck tie tie neck ties neckties mens ties mens neck ties men neck ties cheap ties ties black neck ties cheap neck ties cheap ties dress ties men neck ties mens neck ties mens ties neck tie tie neck ties neckties mens ties mens neck ties men neck ties cheap t

  22. ????????? says:

    4款民族风街拍编发发型 编发新潮流!    民族绝不等同于喜庆,它也可以兼具潮流感又不失个性。甚至你也可以尝试有些蓝调味道的慵懒民族

  23. Este particular Utilizando información,, vas a easilydo su comercialización con la cifra mínima acción hustle.AWWE consiguiente manifiestan como a muñeca inspirada en WWEsuperstars.tradicioneshan cambiado sobre el y no sólo necesita los artículos Incluye el anillos se configuran por cambió estos días,Zapatillas Nike Free Mujer, los hombres también suelen ser también llevar un anillo un anillo de compromiso como símbolo de duradero amor,

  24. Artículo internet | 21 de julio 2014 Así que la primera TI historia cuenta instrucción sobre readingthe formato JPEG. Último año científicos mediante el planetas placedinstructions proyecto en la lectura del formato JPEG en cualquiera cápsula especial,Zapatos Air Jordan Hombre Barato. Fue posteriormente coloca INTH ,Chaussures Brooks Femme… Así que los primeros TI sencilla instrucción sobre readingthe formato JPEG.los artículos de Internet | 15

  25. ????????? says:

      兴业证券:蓝筹股行情无望纵深发展  8月份的宏观经济数据显现经济过热状态有所减缓,微观经济的安康发展有益于蓝筹股的业绩发展&#1

  26. You may think that big firms are expensive and small companies are very unreliable. This isn’t forever the situation the item behooves the purchaser to review the company’s financial strength together with support services record. Two websites which also be familiar with such evaluations are:•    A,scarpe lacoste uomo prezzi.M,.Inner organs basic resist finished is almost always to make available a considerable number of companies or providers with a similar detail and a

  27. ???840???? says:

    1000 1020双层压瓦机设备 我们本着以产品质量是企业生命,用户满意为服务目标为质量方针;以积极进取、不断创新、追求卓越为企业理念,也是我公&

  28. 想飞e says:

    更年期男性癫痫怎么早期诊断?_癫痫病众媒体追捧的最新癫痫病治疗方法轰动全国。 随着生活的步调的加快,一些中年的男性也成为患癫痫的患者,为什么会导致我们周围的更年期的癫痫患者的人群增加呢?为了及早的预防癫痫对更年起男性的危害,怎么样的表现疹状是更年期的男性癫痫症状呢?更年期男性癫痫怎么早期诊断?   近年来,偏头痛与癫痫的关系引起了广泛关注。据调查,2%-3%的偏头痛患者有癫痫家庭史,6%-8%的偏头痛患者有癫痫发作。有人认为儿童偏头痛发生病变导致癫痫,还有人提出偏头痛与小儿良性癫痫有一定关系。   在临床上,偏头痛与某些癫痫相似,特别是自主神经性癫痫有许多相似之处,如都具有发作性,都可有先

  29. 近年来都选用哪些方法治疗癫痫病癫痫病的出现没有人是不害怕这种病的,癫痫病患者需要对这种病的出现积极的选择好的治疗方法,只有选择了好的治疗对癫痫病的患者才有好处,那么,近年来都选用哪些方法治疗癫痫病?下面让专家来给我们简单的解答一下。1、药物治疗:药物治疗是主要的治疗癫痫的方法之一,也是应用最多成功率最高的治疗方法,被广大医学专家所采用。药物治疗分为西药治疗和中药治疗,其中西药治疗被国际上所有国家采纳,中药治疗主要是中国和少数其它国家采纳。2、手术治疗:国内外都在开展和不断探索,就是通过开颅手术切除癫痫灶或阻断传导通路的方法。这种方法近年来得到了较快的发展,手术例数在逐年上升,手术方式也在不断推

  30. 想飞y says:

    癫痫病的病因|癫痫病发作|癫痫专业医院_癫痫病癫痫病的病因都包括哪些?癫痫发作反反复复使癫痫患者对治疗失去信心,甚至产生放弃治疗的想法,追究其最终原因,是由于患者没有明确查出癫痫病的病因,导致癫痫病错误诊断,癫痫治疗适得其返,病情反反复复,那么临床上癫痫病的病因有哪些呢?  专家孟银花主任表示:癫痫病重复发作的病因主要有以下八点:  1.自行停药或减量过快;2.三十岁以后发病者停药后的复发率在50%;3.控制前发作频率高、疗程长者复发率高;4.大脑有器质性病变者;5.肉体发育障碍者;6.停药前脑电图异常者,特别是重度异常者;7.停药前血药浓度高者;8.某些发作类型:如复杂局部性发作,小发作变异

  31. 想飞o says:

    怎样治疗由脑外伤引起的癫痫病治疗癫痫病的方法都有什么,癫痫病治疗的最好方法是什么呢!癫痫病是一种比较常见脑部神经异常的疾病,相信大家对它并不陌生,它给我们的身体带来了很大的伤害,下面就让我们为大家介绍一些治疗癫痫病的方法,帮助大家能够早日远离癫痫疾病的困扰。治疗癫痫病的方法都有什么,癫痫病治疗的最好方法是什么呢!在现实生活当中,有很多的人患上癫痫病以后不知道应该如何进行治疗,特别是脑外伤所引起的癫痫,脑外伤癫痫属于继发性癫痫,因为有明确的病因,也容易早发现治疗。当然,预防脑外伤癫痫的发生也是很重要的,脑外伤后癫痫发作,您知道癫痫病的症状有哪些吗?有些仅有一次就不会再发作,有些则会复发,这些都需

  32. 外伤性癫痫的术前要注意什么外伤性癫痫也是现在多发的众多癫痫病的一种很常见的类型,这种类型的癫痫同样会给患者的身心带来很大的危害,目前手术治疗外伤性癫痫是应用比较广泛的一种方法,那么外伤性癫痫的术前要注意什么呢?下面来听听专家的分析。 术前应认真进行癫痫源灶定位,因为脑损伤后的瘢痕虽为外伤性癫痫的病因,但引起癫痫发作,却往往是位于病变附近的(偶尔是远离的)痫性放电灶,有时甚至是多源性的,故手术时不仅要切除脑瘢痕组织,同时,还必须切除貌似正常的痫灶,否则癫痫不能控制。 手术宜在局部麻醉或静脉麻醉下施行,以便术中描记皮质电图及电刺激。如果头皮留有较大的瘢痕,手术切口应考虑到头皮的血运供应及整形修复设

  33. 想飞B says:

    癫痫病的治疗是不可盲目“补脑”患上癫痫病就是很难去除的,癫痫病病人要想到对自己的患上的这种疾病,积极的注意一下好的治疗办法,对选择好的治疗方法对很多癫痫病人有着很大的好处,那么,癫痫病的治疗是不可盲目”补脑”?下面让专家来给我们解答一下。”哪病补哪”就如同”吃腿补腿、吃眼补眼”一样,在民间有非常高的流传度。有九成的朋友都知道,癫痫是指人体最重要的大脑,出现发育缺陷、神经受损、外伤感染等造成的疾病。其会给人体智力造成不成程度的障碍、破坏肝脏功能、使记忆力衰退、四肢软弱无力,且发病非常突然,经常在人们毫无察觉或者忽视的时候突然发作。严重的还会患者日常生活、学习、工作造成不可预计的影响,也会使身体在

  34. 癫痫患者怀孕期间怎样合理用药癫痫的危害人们是难以预算的,很多的人认为癫痫不是大事,但是癫痫的危害是很大的,生活中人们不要忽视癫痫的后果,要注意了解癫痫的处理方式方法,及时的治疗。在怀孕期间抗癫痫的药物要这样调整呢?下面我们就来详细说说:服用抗癫痫药的母亲生的孩子发生畸形的几率是正常人群的2-3倍。抗痫药物仅仅是造成这种危险性的一个方面。母亲的健康状况也是重要因素。病人采取多种防护措施以使这种危险性下降。90%以上的服用抗痫药的妇女生育的孩子是完全正常的。继续抗痫药治疗:除了少数在计划怀孕前发作已停止多年,辅助检查已没有异常的病人,可在受孕前逐渐减少和停用抗癫痫药外,大多数病人在受孕和妊娠期应继

  35. 儿童癫痫病的五临床特点是啥?儿童癫痫病的五临床特点是啥?关于儿童癫痫病的临床方式大致的被分为五个方面,那么儿童癫痫病的五临床特点是啥?儿童癫痫病的五临床特点是啥?儿童癫痫病的五临床特点包括有:癫痫病获得因素,即脑部有癫痫性病理改变,这些获得性脑损伤引起脑的结构性或代谢病变,产生癫痫灶,病变可以是弥慢性或局限性、静止性或进行性。脑损伤的原因很多,但在儿童多为先天发育异常、产伤或外伤、脑部感染、高热惊厥等。儿童癫痫病的五临床特点包括有:癫痫病遗传因素,目前人们已经认识到癫痫与遗传有关,而且对儿童癫痫的影响更大。具体表现为不但癫痫本身有遗传倾向,而且对一些其他遗传性疾病来讲,癫痫症状也是经常见到的,

  36. ??760?????? says:

    压瓦机|止水板|c型钢机|彩钢瓦设备|角驰压型机|双层压瓦机|数控复合板流水线_金利压瓦机械厂 压瓦机|双层压瓦机|三层压瓦机|止水板|c型钢机|彩瓦&#357

  37. ?????????? says:

    一声长叹三十年,注重自身形象做文明北京人,如何祛除青春痘六月悲雪重沧海砭骨寒冷晴何日沁园春里有春天

  38. ????????? says:

      话说作为一个单轮平衡车费深玩家,对 solowheel 如许的号称独轮平衡车界的鼻祖,一切平衡车都是盗版他们家的牛逼品牌我应该顶礼跪拜,趋附&

  39. ?????? says:

    雾灵山在线               雾灵山环境教育游 环境教育型游览勾当是顺应社会提高国民素质的需求,向国平易近展示优秀生态&#

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>