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版本上试验一下。

About Eagle Fan

oracle dba
This entry was posted in oracle 11g. Bookmark the permalink.

435 Responses to 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. El Bulldog francés es un can de tamaño pequeño, aunque fuerte y musculoso.

  10. - 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

  11. “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

  12. SKD11??? says:

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

  13. 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

  14. Great article! We are lonking to this particularly great article on our site.
    Keep up the good writing.

  15. 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.

  16. ??? says:

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

  17. u1cityb says:

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

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

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

  18. À 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

  19. 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

  20. ????? says:

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

  21. 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

  22. 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.

  23. whenever you are older women go for cheap dress ; all those female not necessarily just fall for reasonable value ranges in addition to seek request for clothing accessories with modern apparel varieties not to mention day to day functions. the cheap women suits textile manufacturers tend to be cognizant of women necessities in addition to wants. is without question these kind of bottoms, often the producers currently employ of course meaning-For the center reducing lessons and are producing and

  24. a says:

    I’m гeally enjoying the theme/design of уour weblog. Ɗo you eνer run іnto any web browser compatibility issues?

    Α couple of my blog audience Һave complained аbout my blog not operating correctly іn Exploorer ƅut looks great in Opera.
    Do you ɦave any recommendatfions tо help fiх thbis issue?

  25. I was able real way to make your penis bigger (jammiestips.tumblr.com) find good info from your blog articles.

  26. Excellent post. I was checking constantly this weblog and I am impressed!
    Very helpful info particularly the remaining part :) I handle such information much.

    I was seeking this particular info for a very long time.
    Thanks and good luck.

    My page get your dick big

  27. If you desire is it possible to get your penis bigger increase your familiarity just
    keep visiting this website and be updated with the latest information posted here.

  28. Also, the firm stands firmly on the rear of this solution, they usually are going to furnish money back on all unused solution, if returned inside 90 days of obtain. So, in case you are a smoker hoping to quit, why don’t you retain in mind working with this conceptl finishsmoking merchandise so that you’ll be able to finally say goodbye to the illeffects of smoking for good?New 365 days arrives with heaps of exciting and frolicking and a great deal of resolutions far too. everyone has one partic

  29. In warmer conditions, have the potential to apply snowboard pants only. Cheap nfl jerseys Burberry Bags with many producing disorders can be found at a lot of these stores as about 50 % of their very own precise price ranges throughout traditional shops in addition to stores. In warmer conditions, potentially have to work with snowboard pants only. cheap nfl jerseys “I told my plan to Fritz once, and he said it was just what he would like, and agreed to try it when we got rich. The guard was con

  30. This Dragon Blaze Hack Tool is completely safe to use
    and has been tested and tried as well, so you have nothing to worry about.

  31. This course utilizes basic Web animation techniques and software for multimedia
    and web site design.

  32. Uncover showtimes, watch trailers, browse photographs, track
    your Watchlist and price your favorite movies and Television shows on your telephone or tablet!

  33. A study published from your American Journal of Clinical Nutrition (Vol.83,zapatos christian louboutin 2015 mujer,pp. 9415-9445) re-examined the state nutrition education in medical schools. Actually,zapatos salomon barato, besides driving my car from your daylight (which illuminates or exposes my dirty windshield),zapatillas running asics mujer baratas, I elect to drive my car limited to night-or on overcast days.Getting familiar with majority of us unknowingly like the entire body.

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>