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

也有可能是一些patch导致的问题,大家有兴趣也可以在自己的11203版本上试验一下。

426 thoughts on “11203的parse count(total)中不包含softer soft parse

  1. BUILD YOUR CARNIVAL About A Genuinely Good THEME It is crucial to know what kind of people will probably be attending your carnival. This demographic understanding will allow you to in deciding what sort of a theme to decide on and what sort of activities will make you essentially the most money. Essentially,, make sure you are giving your audience what they want. If karaoke is common, give them a karaoke booth. If a football throwing competition could be common, give them that. In the event you

  2. They have won a total of 37 PAC-10 conference championships. They’ve been in a total of 47 bowl games given that the plan started. This trails only Alabama as getting essentially the most bowl appearances. Nevertheless,Nike Free 5.0 + Womens Running Shoes Blue Light Gray, they do have probably the most bowl wins at 31. They’ve recorded a record 7 straight seasons in which they had 11+ wins. Also, a record 33 weeks ranked as the #1 team in college football. USC has numerous players to get awards

  3. Rank: twenty four beyond air jordan homme 97 165 Rank: 1949 beyond 97 $6, 105 Rank: ?NewsID=139 44 beyond ?mod=space&uid=65024 97 $37 Average: ?threadid=285489 $32 2 Average: ?aid=4858 only two ?site=news_comments&newsID=9/ Ronan, 59864 ?NewsID=595 Mass Immunization Roster Biller ?mod=viewthread&tid=283271&pid=1578051&page=1&extra=page=1#pid1578051 333 Rank: 1949 beyond 97 166 Rank: twenty four beyond 97 $4, 989 Rank: 50 ?NewsID=149 beyond ?mod=viewthread&tid=1775777&pid=1845999&page=1&ex

  4. Straightforward Scout,Nike Free 4.0 V2 Anti-Fur Mens Dark Red Running Shoes Let’s take an example, a 43 Reverse play. Let’s say your team got the following yards the 5 times you ran it: -5, 0, -7, 1, 80. The typical yards per carry would have been about 14, a good average correct? Stats could be a extremely powerful tool when employed correctly. One of the very best youth coaches I know (Eric C) is really a professional statistician and has been making use of variations of this model for years.

  5. A transponder would recurrently transmit the vehicle’s position, up and running,ヴィトン オーストリッチ 長財布, Speed and info 10 times per second in all directions using radio signals similar to Wi Fi. Cars would receive the same information back from other motor vehicles. a vehicle’s computer would alert the driver to an impending collision. The JOC West has been placed under the charge of the Commander in Chie

  6. Shoulder patches are a lot more than just fashion. The use of the shoulder patches began for the duration of the American Civil War, when the Union Army began making use of cloth patches. In the course of World War I, Common Pershing authorized the use of shoulder patches for the American Expeditionary Force in France. During World War II, virtually all of the US Army was officially using shoulder patches. These patches however, had been not called patches inside the official language. They had

  7. In The Yellow-Lighted Bookshop, San Francisco author Lewis Buzbee does something few writers would be learned to: he makes the history of the paperback and the bookstore something you equitable cant put down. Buzbee has written either fiction and non-fiction,plus has the aptitude to paint a vivid image with very few words; meantime he describes a favorite bookshop aboard a dark rainy Tuesday amid November, you tin feel the biting atmosphere plus discern the inviting heartiness of the store becko

  8. Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:”Table Normal”;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-parent:””;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:”Calibri”,”sans-serif”;mso-ascii-font-family:Cal

  9. - Hvordan vil du beskrive ham? På hver sin kant er brødrene i kontakt med teamsjef Malcolm Wilson og sonderer Parajumpers Salg for å kjøre fabrikkbil ved siden av finnen Jari-Matti Latvala. Fotografen snur seg, og titter enda en gang inn vinduet til Ari og Susan. Alt vi kjøper av varer og tjenester er momsbelagt. Parajumpers Jakke Heleriet skal innbefatte alt fra turboladere, seter, bremsedeler til klær. Denofa fabrikker i Fredrikstad er en av de store matoljelevera

  10. “Yili Wang Nan Zhang monté la ligne, entre la date de l’Shen Ouest Masayuki voir une croix de berger sur le dos de la vache, soufflé à la bouche du Piccolo suprême soupira et dit:.” Pas aussi bien que je peux! “Puis volé concept de cowboy vache grève a également arrêté flûte, cuit comme la Cour suprême, a déclaré:.” Pourrait briser les Turbans Jaunes, Liu Xuan général Non? “Xuande Jingwen dit:” Ru est les enfants du villa

  11. 孙岩紫是重庆江津人,1995年毕业于重庆工学院统计专业。大学毕业后,孙岩紫在重庆一家国有铸造企业做统计工作。生性不甘平庸的她到后来越

  12. Ava Gardner, ” your lady stated to your ex boyfriend within you time. Evans caused the fitfully designed for several months and even, once in a while, awarded the pages of content to enjoy a book. Then simply, it seems like, your lady possessed moment brain,Hollister Online Shop, considering Evans’s words immediately stops. At a summary epilogue with the arrange, E . d . Victor, Evans’s fictional solution, instructs everything that she or he thinks about manifested. It appears

  13. One of them was so severe that he could barely get up on his own. Evidence
    exists that blocking cytokines may slow down cartilage loss.
    For baby boomers who are concerned about the visible effects of aging, especially in their faces, and would like
    to try something that may help eliminate or at least
    minimize wrinkles and such, it might be something worth looking into.

  14. 网站主页|公司简介|产品中心|公司新闻|行业新闻|技术文档|企业文化|在线留言|销售网络|联系方式|复合板系列|角驰压瓦机系列|数控止水钢板机|广&#21578

  15. 【淘厦门】最牛体验购 好礼送不停
    2月8日上午,全新的线上购物平台【淘厦门】在厦门百脑汇、五一广场举办了“最牛体验购,好礼送不停”的购物体验及送礼活动。
      活动现场,摆满了补水滋润的面膜、去污新神器的洗衣片、美味营养的果蔬干、甜蜜奶香的牛轧糖、方便可口的早粥、绿色健康的银耳…这些,都是【淘厦门】送给大家的免费礼物。
    百脑汇现场人山人海
    帅哥美女扫描下载,热情高涨,现场礼品丰盛送不停,五一广场现场一片热闹.

    礼品不够送啦
    小编了解到,领取礼品的方法也非常简单。只需要关注“淘厦门淘小妹”微信公众号,并下载“淘小店”APP,完成指定操作,就能把所有礼品带回家。
    现场用户还可以用微信扫描“淘小店”二维码购买智利大樱桃和进口海鲜套餐,【淘厦门】承诺同城48小时内送达。波士顿龙虾、爱尔兰蛏子皇、日本贝柱……这些都只要坐在家里等着就有了。
    【淘小店•淘厦门】是阿里巴巴百川计划重点发展项目之一,以阿里大数据为依托,整合了厦门同城以及周边城市的优质商品,为厦门市民所提供的同城移动购物平台。
    此次淘厦门最牛体验购,已龙卷全城!任性送礼,你还不来吗!!!

    扫码下载,淘厦门最牛年货优惠购!

  16. À finae d concos, es 3 gagnants se veont offi des bosesLe défi est e sivant : pogamme ‘Inteigence Atificiee d’n je vidéo, pende e contôe d compotement d’n éément d je et tente de batte ses compétites ! Je me vois bien paton d’n petit bistot. Bizarre que le maire ait laissé faire cela . Les chevax qi sont a top dans ce endez-vos sont tès sovent à ‘aivée os d denie dimanche de janvie. La pojection d docmentaie de Baie Gavin Living in the Pesen

  17. MOSCOW plus LOS ANGELES, May 11 /PRNewswire-FirstCall/ — Amenable Synovial Commodity Enterprise “Vimpel-Communications” (“VimpelCom” and also a “Company”), now proclaimed this Alexey Reznikovich appeared to be selected Chairman of your Plank with Owners in the interacting with with VimpelCom’s Plank with abercrombie winter jacket Owners organised now. That it was the hollister t shirts earliest interacting with abercrombie coupons printable of your innovative Plank with Owners selected along at

  18. 尊敬的~玩家你们好我们提供专业的真人服务,2015【BBIN】平台全新优惠,2015年最新优惠政策 羊年最刺激#世界顶级BBIN平台¥唯一正版真人游戏 VIP专属~一流的&#

  19. 1 from the loveliest locations you are able to select for the wedding is really a garden. The setting inside a botanical tony bowls prom dresses garden provides an aesthetic beauty like nowhere else. Perfectly manicured lawns, several blooming flowers, and beautiful backdrops are only a part of the cause you’ll want your wedding inside a botanical garden. The background not just sets off the ceremony, however the photo possibilities to get a botanical wedding make beautiful prints. The selection

  20. You can visit an urologist in Des Moines, speak about your condition, get diagnosed and choose the treatment
    that you are comfortable with. The problem of women incapability can be due to hormonal change after
    giving birth to baby or due to strict sex education. This may also be useful if you think you may have other psychological problems such as depression.

  21. So next Wednesday night a href=”http://www.lilen-raybanglasses.com/lens-types-raybanglasses-lilen-37.html”>Ray Ban Sunglasses Lens Types in Ray Veto Sunglasses Lens Kinds Toronto, a lot of in Fresh new Arrivals Ray Debar Sunglasses the automotive market Ray Suspend Sunglasses Collections will gather at a Convention Hub in downtown Barcelone to a href=”http://www.lilen-raybanglasses.com/collections-raybanglasses-lilen-35.html”>Ray Ban Sunglasses Collections honour finally, the year’s best digital camera creative available at Marketing’s annual Computer Marketing Ribbons. A newcomer to case for 2010 often is the statement of the Electric a href=http://www.lilen-raybanglasses.com/shop-by-model-raybanglasses-lilen-38.html”>Ray Ban Sunglasses Shop By Model Media Agency Basketball player of the 12 months, Ran Prohibition veto Ray Ban Your next sunglasses Frame a href=”http://www.lilen-raybanglasses.com/”>Ran Ban Sunglasses Wholesale Types Sunglasses Wholesale sponsored through process of Canwest. The very winner was particular from a detail outline of 10 deserving candidates identified as a result of Promotion Canwest. When being purchased, the finalists shared a number of highlights of Beam Ban Sunglasses Cheaper Outlet bygone times year-biggest a href=”http://www.lilen-raybanglasses.com/best-sellers-raybanglasses-lilen-31.html”>Ray Ban Sunglasses Best Sellers achievements, biggest a href=”http://www.lilen-raybanglasses.com/new-arrivals-raybanglasses-lilen-9.html?zenid=24t8k2i2brs0h81pkvg8ikc6i5″>New Arrivals Ray Ban Sunglasses professional achievements, as a result on-for evaluation by Marketing’s as well as combined with DMA co-chairs Adrian Capobianco also John Kasprow, exactly who eventually identified the main winner. Finally the Ray Ban Tinted glasses Best Sellers ten finalists selected with regard to their stellar marketing achievements over the digital yard might be: •Carolyn Present, •Matt Devlin, ZenithOptimedia •Sean a href=”http://www.lilen-raybanglasses.com/frame-types-raybanglasses-lilen-36.html”>Ray Ban Sunglasses Frame Types Dixon, Karat •Jeff Naylor, MediaCom •Avishag Regev, MediaCom •Raymond Reid, Kitchen tools Ban Sunglasses Go shopping By Unit Starcom MediaVest Set •Daryl Stansfield, PHD •Travis Saint. Bliktis, Mediaedge: cia •Jeremy Simpson, M2 Simple •Pamela Turner, OMD The main Digital Marketing Awards will cap from all the first functioning of Marketing While in Toronto November. 10. Tickets and also the precise product information about Marketing and marketing Week, your DMAs and also the Media Technology Awards, of which take place a href=”http://www.lilen-raybanglasses.com/”>Ray Ban Sunglasses Cheap Outlet on Nov. tretton, is on the market from here.

    http://www.lilen-raybanglasses.com/

  22. Shanghai ophthalmology spaceNovember 13, most of insiders who broke what is this great, said Yao Chen and friends might be leaving for New Zealand, this voyage is mainly for weddings. At the, Shanghai microblogging users MiYa_Q grace and On hour double good little butter the nose are micro-Bo said Yao Chen met by the airport, MiYa_Q grace:. To open their email list to see Yao Chen Zhang premonition next month stage can be very busy , S double positive little butter nose, also suggested: In the A

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>