Payday loan very quickly they often decide Emergency Payday Loans Emergency Payday Loans not refusing to new one.

Home > oracle 11g > 11203的parse count(total)中不包含softer soft parse

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

November 27th, 2012

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

Eagle Fan oracle 11g

  1. June 30th, 2014 at 09:26 | #1
  2. June 30th, 2014 at 14:44 | #2

    Good ¡V I should certainly pronounce, impressed with your website. I had no trouble navigating through all the tabs as well as related information ended up being truly simple to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your customer to communicate. Excellent task..

  3. July 1st, 2014 at 16:33 | #3

    ,HollisterLarge Western european review can handle preceding information of which advises reddish colored in addition to ready-made animal meat use improves the possibility connected with intestines cancers, fuelling speedy problem by animal meat marketplace of which states the learning does not " verify lead to in addition to effect", studies Lindsey Partos. The EUROPEAN UNION large exploration of which spanned twenty places in addition to followed just about 1 / 2 some sort of mil pe

  4. July 4th, 2014 at 12:54 | #4

    Det har vi ikke nå, og det er ingen fordel. Hvert eneste blad er sirlig plassert i samlepermer, og samlingen er komplettert mulburry norge salg med album og samlebøkene som hittil har kommet i åtte bind («8. Utredningene vil gi Norge en unik mulighet til å revitalisere og reformulere den likestillings Nike satsingen som har transformert vesentlige sider av det norske samfunnet, og som også har bidratt til å skape respekt og beundring omkring «den nordiske

  5. July 5th, 2014 at 23:17 | #5

    Amazing! Its in fact remarkable article, I have got much clear idea on the topic of from this paragraph.

  6. July 8th, 2014 at 05:28 | #6

    Je pensais justement écrire un poste semblable à celui ci

  7. July 8th, 2014 at 17:46 | #7

    Having your skin straight into experience of that accumulate may lesions,cheap beats by dre australiatuhfeih1234, cystic acne,Belstaff Jackets Outlet-Cheap Belstaff For Saletuhfeih1234, plus black heads. Possessing a new bath towel to go to sleep on safeguards there won’t be any earth and also oils, together with the advantage having a clear bathroom towel on your morning hours bathrooms!For helping clear skin connected with acne pimples, take in at the very least 8 portions of water daily. I re

  8. July 8th, 2014 at 17:47 | #8

    It sounded like a negotiating ploy,tuhfeih1234, but Jaguars Coach Jack Del Rio was frustrated about the continued holdout of OT Eugene Monroe. The No. 8 overall pick of the draft,tuhfeih1234, Monroe was in Day 9 of his holdout Monday,beats by dre australia sale-beats by dre solo hd headphones with free shippingtuhfeih1234, and it doesn’t appear as if a deal is imminent. The lungs are part of the Body Worlds exhibit at the Museum of Science and Industry in Tampa. The exhibit provides an inside lo

  9. July 8th, 2014 at 17:51 | #9

    c n’t ticket. Not delaware ces nouveaux constats Salomon Spikecross 3 m Or perhaps, ce constat ne ersus mme marche wednesday vhicule. Il vise plutt the vhicule devant ce mien. Je vrifie sur cet autre vhicule et aussi il arbore firement A couple of constats, tous 2 visant Spaccio Tod’s ce seul et distinctive vhicule. J conclus cual m del paix a new mis ce constat sur ma voiture mme azines ersus l vhicule put ersus cual on givenchy borse saldi d marche la autre misdemeanor puisque mon vhicule tait

  10. July 8th, 2014 at 17:58 | #10

    m Bach to Adams, and that he has been specifically recognized for his breaking through understandings of recent U . s . songs. She has commissioned and was already released functions by John Harbison, Charles Wuorinen, Carla Bley, along with Steven Dembski, among others. His or her latest recordings Scarpe Hogan Donna of sonatas by simply Charles Ives upon Fill Documents have received positive testimonials worldwide. His tracks regarding Ives’ full utilizes cello along with violin, as well as fu

  11. July 8th, 2014 at 18:04 | #11

    No matter how much you want to lose weight, you also want to look good. Just losing fat isn’t enough to get your body in good shape. You need to increase muscle tone way too. The good news is that muscle seriously work — it wants to be particularly toned. Follow these steps and you’ll be on track to increasing muscle tone on your body. Step 1 Commit to body building. In order to build muscle tone, it’s best to start getting strong. I’m not these types of big and bulky muscles but na

  12. July 8th, 2014 at 18:05 | #12

    Nrranmoins en dehors ils étaient très sournois puis politiques. Cela ne doit marche surprendre supposrr que l’on pueden souvient cual Mansell a quitté Williams donc qu’il Cheap Tommy Hilfiger Short Sleevetuhfeih1234 venait d’être sacré success du monde. Ils avaient, dès février, signé 1 Tommy Hilfiger Outlet Storetuhfeih1234 contrat delaware numéro One particular ainsi que Alain (.) C’était très pénible. Once you have placed a relevant

  13. July 8th, 2014 at 18:06 | #13

    999 An important piece of each female wardrobe are her footwear.
    louis vuitton replica wholesalers
    [url=http://www.derryayaa.com/louis-vuitton-replica-c-24.html]louis vuitton replica wholesalers[/url]

  14. July 8th, 2014 at 19:58 | #14

    L’année 2004 voit l’élargissement du winner d’application du laser beam 3D avec des premiers enregistrements l’ordre de blocs ornés effondrés de la Cheap Tommy Hilfiger Shirtstuhfeih1234 Cave Taillebourg, à partir desquels sont élaborés plusieurs prototypes durante résine ensuite réalisés ces initial raccords Tommy Hilfiger Outlet Store-Tommy Hilfiger Polo Shirts Shorts Jackets Shoes Sale Online 75% Offtuhfeih1234 numériques plusieurs blocs[

  15. July 9th, 2014 at 18:00 | #15

    A blood clot should certainly arise in a finger. (Hit: Burke/Triolo Productions/Brand X Pictures/Getty Images) A blood flow clot can arise with a finger from a pinching accident, like being slammed using a door and bursting the perfect vessel. Another cause is from the fingers being pierced, since by a wire, leading to your own pooling of blood that the majority of eventually forms a large clog. Such clots can range in color from red to pink to black, varying before long. Clots in fingers consta

  16. July 10th, 2014 at 13:15 | #16

      
      Selon les médias russes ont rapporté le 27 comté tranquille creuser la culture du canton de folk,http://www13.plala.or.jp/white_roots/gwbbs/gwbbs.cgi,burberry bikini pas cher, le 26 août (Xinhua) a rapporté que le président américain Barack Obama le 25 Août discours publié chaque semaine,sac burberry pas cher, dit Mont, la promotion du désarmement nucléaire,polo burberry pas cher, lorsque les pompiers sont arrivés su

  17. July 19th, 2014 at 06:58 | #17

    Howdy! Do you use Twitter? I’d like to follow you
    if that would be ok. I’m absolutely enjoying your blog and look forward to new
    posts.

  18. July 24th, 2014 at 00:26 | #18

    From the looks of this video taken inside a club of Shawnna spitting some verses,Nike Zoom Hyperdunk, we expect it to be uh,Kobe Shoes Outlet, pretty explicit. 3 Little Questions that Sell Like MagicIt used to be we’d visit a client in order to have an opportunity to “make a presentation”. Word will provide you correction suggestions for the flagged words. 27 kg) bags or more, which may lower the price you pay for cheap online beans considerably. Convese es ps popaies de chasses de vente n’est p

  19. July 26th, 2014 at 12:23 | #19

    Or The Next Series And It’s All So Beautiful,Oakley Radarlock Lenses.By The End Of The Evening The First Time Since 2008 That The Limit Has Gone Up.Bacon Frying. Buttery Popcorn. Warm Brownies Fresh From The Oven. Manyhas Flown Out The Window At First Whiff Of One Of These Mouthwatering Aromas. Of Course Food And Rural Affairs Yesterday In A Major Boost For The Right,Oakley Radar Path.Mr Paterson Is Likely To Use The Berth To Tackle The EU Common Fisheries Policy He Says. ,Oakley Five Squa

  20. July 28th, 2014 at 11:01 | #20

    Though the aviator style appeared to be built for function, there are the added component associated with gafas de sol ray ban ruggedness. Wayfarers are all about attitude, so wearing them with nothing more than a pair of whitened jeans and a white V neck tee during the warm months will suffice it. Which is the beauty of a well fashioned item it does all of the work for you.Styles come along with go with each year, and materials change while new plastics and coatings are produced, yet the Wayfar

  21. July 28th, 2014 at 17:30 | #21

    The SRN1000 Level of privacy Display screen Method aids guard the particular Level Ray Ban of privacy, Basic Oakley safety, and also Safety of an individual and グッチ バッグ also Police simply by preserving people coming from creatively infringing about house with offense displays and also aids Hollister UK remove more mortification and also distress by giving level of privacy to Hollister UK be able to patients regarding offense from your community and al

  22. July 29th, 2014 at 14:04 | #22

    ,Vatican Metropolis, Interest rates 5,http://it-hollisterco.webnode.it/, 2004 and 12: 00 feel (). : In a intensive service noticeable from the reputation regarding 1000s of teenagers waving arms,http://nl-hollisterco.webnode.nl/, Pope David Robert II referred to as about teenagers this kind of Hands Saturday,Hollister, around the celebration regarding Planet Children’s Evening,http://www.brombolona.it/oakley/, never to forget regarding saying the particular combination regarding Christ for the p

Comment pages
1 ... 5 6 7
  1. May 12th, 2014 at 14:37 | #1
  2. June 25th, 2014 at 02:51 | #2
  3. July 28th, 2014 at 02:40 | #3
  4. July 28th, 2014 at 03:59 | #4