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

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

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>