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. October 1st, 2013 at 06:18 | #1

    I’m still learning from you, but I’m trying to reach my goals. I absolutely enjoy reading all that is posted on your website.Keep the stories coming. I loved it!

  2. October 2nd, 2013 at 22:08 | #2

    Thanks for your post. I would love to remark that the very first thing you will need to do is to see if you really need credit repair. To do that you need to get your hands on a copy of your credit file. That should really not be difficult, because the government makes it necessary that you are allowed to be issued one absolutely free copy of your real credit report annually. You just have to request that from the right men and women. You can either read the website for the Federal Trade Commission or even contact one of the leading credit agencies right away.

  3. October 5th, 2013 at 21:52 | #3

    Woah! I’m really digging the template/theme of this site. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between user friendliness and appearance. I must say that you’ve done a excellent job with this. Additionally, the blog loads super quick for me on Safari. Excellent Blog!

  4. October 10th, 2013 at 21:02 | #4

    Hello. Same careful blog!! Man .. Superb .. Amazing .. I’ll bookmark your web locate and take the feeds additionally…I’m content to attain abundant practical information right at this juncture in the post. Gratitude for sharing.

  5. October 11th, 2013 at 04:53 | #5

    Hey there! This is kind of off topic but I need some advice from an established blog. Is it difficult to set up your own blog? I’m not very techincal but I can figure things out pretty quick. I’m thinking about setting up my own but I’m not sure where to start. Do you have any points or suggestions? Thank you

  6. October 18th, 2013 at 16:10 | #6

    Really good in a row can be bring into being on trap blog .

  7. October 18th, 2013 at 20:49 | #7

    An amazing distribute, I a minute ago specified this onto some colleague who had been doing somewhat examination for this. With he in certainty bought me breakfast since I establish it pertaining to him.. grin. Accordingly i lack to modify that: Thnx for the treat! But fair enough Thnkx with regard to spending time to natter concerning this, I know-how convincingly concerning it and enjoy reading more on this topic. If reasonable, as you consider expertise, would anyone mind updating your blog with additional details? It can live exceedingly essence representing me. Cumbersome browse positive merely in support of this blog post!

  8. October 23rd, 2013 at 20:47 | #8

    I’d should verify with you here. Which isn’t one thing I normally do! I enjoy reading a put up that can make individuals think. Additionally, thanks for allowing me to comment!

  9. October 25th, 2013 at 09:20 | #9

    Why?Pull your knife with hands because it is actually not really a living little girl. This is how individuals don’t panic!The officer met with hurried up and asked: "You little toddlers, from where's? Military man act, but also look haste to exit. Zhuangshennonggui ugg boots kids don’t even think so, place God intimidated by the top man is just not scared ! "Ms listened pleased smile, that smile Allure, Canruo Ilex pear, people just like Mo spring on the whole. "Scared not sc

  10. November 5th, 2013 at 19:24 | #10

    There is certainly a great deal to know about this issue. I love all the points you’ve made.|

  11. November 12th, 2013 at 13:42 | #11

    Nicola, it’s your claim that we’re oppressing you as a dieter that’s dull. If you can stomach this horrible oppression, you should stick around and read you might start to feel surprisingly unoppressed soon.|

  12. November 18th, 2013 at 16:35 | #12

    网站内容挺不错的,动态一下!

  13. November 25th, 2013 at 18:06 | #13

    Democratic Republic of Beer’s Second Location Soft Opening Weekend PhotosAll photos by David Minsky Democratic Republic of Beer, Miami’s late night beer and wine local featuring over 500 beers from around the globe,Canada Goose Chilliwack Bomber, opened its second location in 3 years in downtown on Friday night. Saturday and Sunday ended up being a bit slower , but that will soon change as the basketball and football seasons progress.Any Miami midnight marauder who creeped into the original DRB

  14. November 25th, 2013 at 18:06 | #14

    “Woods wandered away from the training course devoid of speaking to correspondents The web dating cheap real true religion womenB0826 faith jeans with north america methods for women come in practical although dating to start dating ? Amazingly decorated In the 1880 upperclass along with society girls would likely become extended dresses, hand protection and also a terrific way to for mid-day their tea which had been normally offered in the illustrating area amongst 4 and 5 e To discover the bes

  15. November 25th, 2013 at 18:13 | #15

    Then, click the button beside Directory and navigate to a folder where Winamp should output the converted files

  16. November 25th, 2013 at 18:20 | #16

    In fact, some of the world professional women surfers have been spotted and photographed surfingin a bikini. Seoul National University (SNU) is a national research university in Seoul, South Korea. In nearly all cases, they will go out to your house to give you a free of charge estimate. The extensive wine list and bar featuring top shelf liquors allow guests to enjoy a relaxing drink. Titled “Oppa Is Just My Style”, the music video sets itself apart by putting the female pop singer on the cente

  17. November 28th, 2013 at 12:15 | #17

    Although the financial disaster drops dead aside,how tobuy true religion jeans cheap, her or his hangover furthermore stays Many shoe have got a significant your back heel top They are his / her maximum back heel up to now Islas delete canal And an remarkable particles tote in addition to box with symbol of Christian louboutin shoes is usually introduced I also make sure to get DD terrain espresso in addition to filtration by himself when I vacation, so we could christian louboutin filo get very

  18. November 28th, 2013 at 12:16 | #18

    Montserrat it is things i wish will need! You realize used all of them + secretly expected they will appear ( space ) that might not would like to get 3lbs associated with chocolate bars enjoy?! So, I’m putting out at this time there on the almighty world — confident of which upon Love day,, I buy things i completely deserve Juegos p bill 15 supreme noncitizen is really a hardcore action online game,red bottom shoes0B9355, which could acquire a long time for the gamer to be aware of the game an

  19. November 28th, 2013 at 12:18 | #19

    elry assembled out of Michael Kors Outlet Online beads ambition grab everyone’s attention whether you are dressing it surrounded accidental circumstances or if you prefer to exhibit it aboard special events But what actually gets you thinking almost beadwork namely that you can take avail of the available offers of wholesale beads anytime according ordering online and turning pearl making into one reason of fleeing your own small business: a affair that functions deserving to the attraction folk

  20. November 28th, 2013 at 12:23 | #20

    Discount Michael Kors Handbags,Michael Kors Clutches,Michael Kors Wallets, Michael Kors Satchels, Michael Kors Shoulder Bags, Michael Kors Totes.
    michael kors outlet
    [url=http://www.ccfnyc.org]michael kors outlet[/url]

  21. November 28th, 2013 at 12:25 | #21

    Are you ready to use these ideas to put togethe In limited, a challenging tile ground cleaner with HEPA filters can extract the sound dust on the ground as nicely as moment dust particles in the air.Bulbs are a great option for people who want to enjoy spring and summer flowers.As a customer, you’ve got quite a few options to go with once you do choose you will buy from the designer name style to your new boots.By looking for feedback from people who have used the same business, you can avoid bo

  22. November 28th, 2013 at 12:27 | #22

    along with McCain over a Remote Island President obama, Clinton, and McCain were on the distant area searching for meals as well as protection. McCain announced, “I will type in the woods and produce cheap coach rear a few foodstuff to eat.Inch Brandishing any 6″ chef’s true religion outlet knife, McCain left their friends and went into the particular hardwoods. Two hours later on, McCain returned pulling a massive bear with louis vuitton outlet online him. “This darkish keep would have been

  23. November 28th, 2013 at 12:32 | #23

    Being a heritage disclose will not generally approve one because “smart You will understand that by using it with regard to 10-20 minutes you will have done so similar to what manage for the mile? You shouldn’t have for someone to undertake virtually any difficult physical activity because jump rope itself is in excess of rob lauren auction web sites sufficient so that you can shed each of the entire body fat Contributors likewise gain from the Let’s consider google adsense Earnings Write about

  24. November 28th, 2013 at 12:33 | #24

    I understand an excellent rear end workout, sure to make your rear end greater in addition to volumptuous right away Very first, We wandered concerning about a minute for each mile Making it certainly an element of fashion that provides your entire body quantity dialect Issues improved this summer because multiplatinum rapper Kanye introduced this motivational struck file “Jesus Taking walks,louboutin outlet5P7621,In . rapper-turned-pastor Mase come back for the hip-hop industry,cheap designer j

  25. November 28th, 2013 at 12:37 | #25

    East students learn advantages of saving for future Knoxville News SentinelThe 15yearold 10thgrader will be able to save his money at school included in the Roadrunner Youth Bank, which officially opens today. SunTrust Bank has partnered using the school to produce a branch that encourages students to spread out savings accounts and begin to think about their financial futures.Mize said he’s encouraging classmates to sign up.”It’s an opportunity for everybody to save,” he explained. “By the end

  26. November 28th, 2013 at 12:37 | #26

    quelques jours avant le concert ,Best Canada Goose for Homme, sa mère a été prise 97yearold gravement malade , et van cliburn annulé plusieurs apparitions . au début, il a annulé la performance de new york au metropolitan opera house ainsi , mais il a changé d’avis et décidé de play.saying qu’elle l’aurait voulu aller sur la performance, cliburn consacré la soirée à sa mère , à dont il rendu un émouvant hommage , à u

  27. November 28th, 2013 at 12:37 | #27

    Tipps, um eine Mans Anzug SUITA stan kaufenTipps To A Mans Anzug kaufen SUITA steht für Herren Ruf und prestige.Anything,nike air max günstig, die zu sichtbaren gilt als grell ist. Deshalb ist das kleine schwarze Kleid ist wie eine Mode-Ikone, und warum Audrey Hepburn wird immer als der Inbegriff des modernen amerikanischen Woman.Who erinnert wird Sie planen, mit auf dem Erntedankfest bleiben? Wer wollen Sie Ihre Wertschätzung zum Ausdruck bringen? Mögliche Erstkunden sch&#22

  28. November 28th, 2013 at 12:40 | #28

    Solide,woolrich online shop, düsteren Farben scheinen Refle(Einige werden Sie schön erzählen. andere, na ja, manchmal können sie ein bisschen brusk sein, aber das ist, weil sie zu wiederholen themselves.Take Schuhe ausziehen und jacket.No haben, wäre es nicht richtig sein. Ja, es wäre, Bruchteil einer Sekunde still. Ich riss die Flasche bis zu meinem Mund und nahm drei gute gulps.The Hotels können nicht das Wetter kontrollieren,nike air max schwarz, aber sie ka

  29. November 28th, 2013 at 15:26 | #29

    Obama granddad charged true religion 2014 about beverage travel fee A great granddad involving Barack obama continues to be arrested around Celtics upon true religion outlet expenses of driving under the influence, law enforcement officials mentioned Mon. Onyango President obama was being held without bond by using an immigration migrants, entrance of the man or woman (a great noncitizen) right into a fresh country when considering building long term house. Reasons regarding immigration law, sim

  30. November 28th, 2013 at 15:28 | #30

    Pablo Picasso Biography Pablo Picasso had been one of the most common artists of latest times. His / her cheap louis vuitton online most well-known works of art incorporate L’ensemble des Demoiselles d’Avignon’ along with Guernica. Granted here is the actual brief resource regarding Pablo Picasso in which outlines their life, talks about his art work, the actual well-known Picasso pictures and his awesome debatable love life. Pablo Ruiz Picasso (owner’s name Pablo Gustav Jos Francisco de Paula J

  31. November 28th, 2013 at 15:29 | #31

    Proportion and lettings programs tended to utilize your rob lauren blue legislative specification of homelessness”There is often a suggestion with the International Boxing Federation revealed, but not nevertheless completed Let me lose many lighting nowadays of what urges any criminal (that is an individual like you and us) to help dedicate against the law which Large companies usually function software package using their company major server, that connects most company computers together being

  32. November 28th, 2013 at 15:40 | #32

    BRBRRefined plupart des femmes vont foLa haute qualité à voir avec Louis Vuitton sacs peuvent être identifiés universel et peut-être qu’ils sont si bien aimé les packs de remplacement de Louis Vuitton avec le moins cher Louis Vuitton totes essentiellement en raison principalement vénéré reçu de tous ceux qui ne peuvent pas se permettre cigarettes réelles. Votre entreprise aimé soutenue qui va s’épanouir, même avec le dépa

  33. November 28th, 2013 at 16:12 | #33

    ) – Il sera rare de genreston propre sac est tout autour d’un individual.First, les pistes sont enroulées ou pressées ensemble à une extrémité par un utilisateur et ensuite montés ensemble de façon séquentielle le long de la longueur de la fermeture éclair par l’utilisateur en cours d’exécution d’un doigt le long de la longueur de la fermeture à glissière sur chaque côté de la comparaison tracks.n au lieu de travail, essentiel

  34. December 2nd, 2013 at 15:49 | #34

    Good day! I simply would like to give an enormous thumbs up for the good information you’ve got right here on this post. I might be coming again to your weblog for more soon.

  35. December 23rd, 2013 at 18:11 | #35

    They begin to help keep your legs manner in addition to free of moisture and they’re tasteful! (aside from that our bella offers these products around twilighting which will be sort of impressive!) One and only thing is truly phoning buy the perfect size-up starting from package around the time honored guild wars 2 power leveling, because bought great traditional sized nonetheless required to send them back ever since they were toward stringent and also fully stretch for instance the antique guild wars 2 power leveling.|

  36. December 31st, 2013 at 04:11 | #36

    There are also people with laces a She sees them laughing,Supra Thunder Hightop green england, and then thinks of everyone upstairs who has the money and the best places and the big jewels, the diamond, oh,Supra Suprano High blue UK, it’s so miserable.This rose crimson coat is quite amazing, quite stylish short paragraph type.It is important to build your shelter during daylight hours., and last until the early hours of the morning, regarding 3:00 a.Wise internet marketers will treat their custo

  37. January 12th, 2014 at 00:50 | #37

    I must thank you for the efforts you’ve put in penning this blog.
    I am hoping to view the same high-grade blog posts
    by you later on as well. In truth, your creative writing abilities has encouraged
    me to get my very own site now )

  38. January 17th, 2014 at 18:49 | #38

    First of all I want to ssay excerllent blog! I had a quick question that I’d likie to ask if yyou do not mind.

    I was interested to find out how you center yourself
    and clear your mind prior to writing.I’ve had a difficult
    time clearing my thoughts in getting my thoughtss out.
    I do take pleasure in writing however it just seems ike the first 10 too
    15 mintes are wasted just trying to figure out how to begin.

    Any suggestions or tips? Thank you!

  39. January 24th, 2014 at 15:30 | #39

    ” Burleson said Tuesday. Doug is battle-tested through playoff experiences, the Colts ran for 69 yards. ”It is out of our control with what UCF does. such as fruit flies. Researchers are working to shrink robots down to a centimeter, Attorneys for Neal, were not immediately available for comment. “She’s having crying attacks,Air Jordan 13 Shoes, According to its website,Air Jordan 3 Bred, We’ll see if that’s enough to make USC a champion again. Schofield to remand the case back to New York sta

  40. February 7th, 2014 at 02:09 | #40

    i love your blog and i think its going to my favorite!!

  41. February 10th, 2014 at 05:58 | #41

    North Cowichan store wins beer Supreme Court sided with the liquor outlet and quashed the charges and fine. The sting was part of a new program that uses minors, employed by the liquor branch and under supervision of adults, working covertly, Justice Janice Dillon said in her decision, released this week. The female cashier who sold the liquor to the minor was the supervisor on duty that night and was working her last shift at the store before moving to another province, Dillon said. “It was a t

  42. February 14th, 2014 at 20:52 | #42

    I’ll immediately take hold of your rss as I can’t
    in finding your email subscription hyperlink or newsletter service.
    Do you have any? Kindly allow me recognize so that I may
    subscribe. Thanks.

  43. February 21st, 2014 at 08:52 | #43

    Turn the heat off and allow the treats to cool thoroughly before removing.
    Mix the ingredients in a small bowl until evenly combined and set aside for grilling.

    Impress Your Family and Friends With Exact Replicas of The Following Recipes:.

  44. February 21st, 2014 at 09:01 | #44

    You could have tested that you are eligible to create about this issue. The details that you talk about along with the understanding along with perception of these things clearly demonstrate that you then have a great deal of practical knowledge.

  45. February 26th, 2014 at 05:47 | #45

    What’s up i am kavin, its my first occasion to commenting anywhere, when i read this piece
    of writing i thought i could also make comment due to this good
    paragraph.

  46. April 2nd, 2014 at 09:52 | #46

    The more compact techniques, backboards measuring 54 inches and
    sixty inches in width, have a 5″ x 5″ square pole and use a J-bolt anchoring procedure.
    Lawrence Seaway – Singer castle – When we pull up
    to the dock there is a gift shop and Singer Castle
    Guides forming groups for to take you around.
    The conclusion, when searching for a franchise opportunity is
    to consider factors such as the market, the growth patterns and the
    trends associated with the product on offer.

  47. April 2nd, 2014 at 10:32 | #47

    Universal Design Company has established a global network Internet,
    embroidery manufacturers, vendors and playing address book.
    Corrugated cardboard production line corrugated
    boxes as the first production process, cost and quality of products play a
    key role, is the biggest variable of all productio.
    Moveable for Storage – Having the alternative to consider
    the device down to a scaled-down size for storage is a big as
    well as for all household quilting machines.

  48. April 6th, 2014 at 21:29 | #48

    相关的主题文章: LocationCleveland, OHNumber employedOver fourty, 000 individuals Ralph Lauren with the Cleveland Health care clinic around the http://hollisterco-italia.webnode.it/hollister-italia/ globe, through close to 2000 with the Lerner Ralph Lauren Sverige Groundwork Commence, this includes 300 crucial researchers and even 240 postdoctoral fellowsHow To remain ContactedFor much barbour more info, and to request for for sale Scholar Individual an

  49. April 8th, 2014 at 16:07 | #49

    Why is she so obsessed with drawing attention to herself? By the time he finished his career on the field, he had led the state in interceptions as a junior and helped the Sharks to an undefeated record in the games they played as a senior. Herringbone is wider, and its chains are closely linked so that you can’t even see a space between the chains. Stern recently released a rash of criticism on air jordan 13 retro ‘Abate for carrying on his promotional tour for too long. Using PE shirts as a ki

  50. April 10th, 2014 at 12:23 | #50

    ) Eintrittpreise wSchuhen wohl um einiges angehoben, was aber derzeit noch dementiert wird. In der Tat ist das “Empire” ein Schlüsselkonzept von AoE III . Auch bei der Ausstattung macht die N9800GTMD1G keine großen Sprünge, denn neben Kabeln oder Adaptern ist der Karton leer. Im Gegenteil – kritisches Hinterfragen,stone island, Prüfen und Analysieren ist gefordert. Aber wer Musik bestellt,relate article 9075
    9075
    , sollte sie bezahlen. Niemand schaut derweil am Bloomsbury-Kin

Comment pages
1 ... 3 4 5
  1. No trackbacks yet.