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. May 24th, 2013 at 04:33 | #1

    We stumbled over here different web page and thought I may as well check things out. I like what I see so now i’m following you. Look forward to looking at your web page for a second time.

  2. May 24th, 2013 at 15:33 | #2

    Howdy would you mind letting me know which web host you’re using? I’ve loaded your blog in 3 different internet browsers and I must say this blog loads a lot quicker then most. Can you suggest a good internet hosting provider at a honest price? Thank you, I appreciate it!

  3. May 25th, 2013 at 13:39 | #3

    you might possess a terrific blog right right here! would you wish to make some invite posts on my weblog?

  4. May 25th, 2013 at 15:57 | #4

    Friday Night Lights is actually a fantastic television series, i enjoy the game and i enjoy the story::

  5. May 27th, 2013 at 17:54 | #5

    I really like your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you? Plz answer back as I’m looking to construct my own blog and would like to find out where u got this from. kudos

  6. May 28th, 2013 at 06:06 | #6

    Please let me know if you’re looking for a article writer for your blog. You have some really great posts and I feel I would be a good asset. If you ever want to take some of the load off, I’d really like to write some material for your blog in exchange for a link back to mine. Please shoot me an email if interested. Regards!

  7. May 28th, 2013 at 07:09 | #7

    I’m curious to find out what blog platform you’re using? I’m experiencing some minor security issues with my latest blog and I would like to find something more safeguarded. Do you have any recommendations?

  8. May 29th, 2013 at 07:45 | #8

    I¡¦ve been exploring for a little bit for any high quality articles or weblog posts in this kind of space . Exploring in Yahoo I ultimately stumbled upon this site. Reading this info So i¡¦m happy to show that I’ve an incredibly just right uncanny feeling I came upon just what I needed. I such a lot indisputably will make certain to do not put out of your mind this site and provides it a glance regularly.

  9. May 29th, 2013 at 11:51 | #9

    I was examining some of your content on this site and I think this web site is real instructive! Keep on posting.

  10. May 29th, 2013 at 12:51 | #10

    Hola! I’ve been reading your website for some time now and finally got the courage to go ahead and give you a shout out from Lubbock Tx! Just wanted to tell you keep up the good work!

  11. May 29th, 2013 at 23:38 | #11

    Great site you have here but I was wanting to know if you knew of any user discussion forums that cover the same topics talked about in this article? I’d really like to be a part of community where I can get opinions from other knowledgeable people that share the same interest. If you have any recommendations, please let me know. Thank you!

  12. May 30th, 2013 at 23:59 | #12

    dress shops that supply discounts are quite prevalent in our location and i constantly shop at them’

  13. May 31st, 2013 at 04:20 | #13

    Hey! Quick question that’s entirely off topic. Do you know how to make your site mobile friendly? My site looks weird when viewing from my iphone4. I’m trying to find a template or plugin that might be able to correct this issue. If you have any suggestions, please share. Cheers!

  14. June 2nd, 2013 at 02:07 | #14

    I like your writing style really enjoying this site. “I’ve wrestled with reality for 35 years, Doctor, and I’m happy to state I finally won out over it.” by Jimmy Stewart.

  15. June 3rd, 2013 at 23:50 | #15

    My programmer is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the costs. But he’s tryiong none the less. I’ve been using WordPress on numerous websites for about a year and am concerned about switching to another platform. I have heard very good things about blogengine.net. Is there a way I can transfer all my wordpress content into it? Any kind of help would be greatly appreciated!

  16. June 4th, 2013 at 06:36 | #16

    I relish, cause I found just what I was looking for. You have ended my 4 day lengthy hunt! God Bless you man. Have a great day. Bye

  17. June 5th, 2013 at 03:18 | #17

    Thanks for your useful article. Other thing is that mesothelioma is generally attributable to the breathing of fibres from mesothelioma, which is a very toxic material. It really is commonly seen among individuals in the construction industry with long contact with asbestos. It can be caused by living in asbestos insulated buildings for a long time of time, Your age plays an important role, and some individuals are more vulnerable towards the risk than others.

  18. June 5th, 2013 at 06:03 | #18

    Hey! Do you know if they make any plugins to help with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good success. If you know of any please share. Thanks!

  19. June 5th, 2013 at 06:27 | #19

    Hello would you mind sharing which blog platform you’re using? I’m going to start my own blog in the near future but I’m having a difficult time deciding between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I’m looking for something unique. P.S My apologies for being off-topic but I had to ask!

  20. June 5th, 2013 at 11:59 | #20

    Do you mind if I quote a few of your articles as long as I provide credit and sources back to your weblog? My website is in the exact same niche as yours and my visitors would genuinely benefit from a lot of the information you provide here. Please let me know if this ok with you. Thanks!

  21. June 7th, 2013 at 04:53 | #21

    I’m curious to find out what blog platform you happen to be using? I’m experiencing some small security problems with my latest site and I would like to find something more secure. Do you have any solutions?

  22. June 7th, 2013 at 07:21 | #22

    My programmer is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the costs. But he’s tryiong none the less. I’ve been using Movable-type on various websites for about a year and am worried about switching to another platform. I have heard great things about blogengine.net. Is there a way I can transfer all my wordpress content into it? Any help would be really appreciated!

  23. June 7th, 2013 at 09:38 | #23

    With havin so much content do you ever run into any problems of plagorism or copyright violation? My website has a lot of unique content I’ve either written myself or outsourced but it appears a lot of it is popping it up all over the internet without my permission. Do you know any techniques to help reduce content from being stolen? I’d truly appreciate it.

  24. June 8th, 2013 at 06:19 | #24

    Have you ever thought about including a little bit more than just your articles? I mean, what you say is important and all. However think about if you added some great images or videos to give your posts more, “pop”! Your content is excellent but with pics and videos, this website could certainly be one of the very best in its niche. Excellent blog!

  25. June 8th, 2013 at 09:15 | #25

    With havin so much content and articles do you ever run into any issues of plagorism or copyright infringement? My site has a lot of completely unique content I’ve either written myself or outsourced but it seems a lot of it is popping it up all over the web without my authorization. Do you know any techniques to help prevent content from being ripped off? I’d certainly appreciate it.

  26. June 12th, 2013 at 04:44 | #26

    Thanks for the sensible critique. Me & my neighbor were just preparing to do a little research about this. We got a grab a book from our local library but I think I learned more from this post. I’m very glad to see such excellent info being shared freely out there.

  27. June 12th, 2013 at 05:47 | #27

    It’s a pity you don’t have a donate button! I’d most certainly donate to this outstanding blog! I suppose for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to brand new updates and will share this website with my Facebook group. Chat soon!

  28. June 12th, 2013 at 17:59 | #28

    Hi there, i read your blog occasionally and i own a similar one and i was just wondering if you get a lot of spam remarks? If so how do you reduce it, any plugin or anything you can advise? I get so much lately it’s driving me crazy so any support is very much appreciated.

  29. June 13th, 2013 at 06:11 | #29

    I know this if off topic but I’m looking into starting my own weblog and was wondering what all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very web smart so I’m not 100% positive. Any tips or advice would be greatly appreciated. Kudos

  30. June 13th, 2013 at 07:45 | #30

    Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your webpage? My blog site is in the exact same niche as yours and my visitors would definitely benefit from a lot of the information you present here. Please let me know if this ok with you. Thanks a lot!

  31. June 13th, 2013 at 17:32 | #31

    Do you have a spam issue on this website; I also am a blogger, and I was wanting to know your situation; many of us have developed some nice practices and we are looking to trade methods with other folks, be sure to shoot me an e-mail if interested.

  32. June 13th, 2013 at 19:14 | #32

    It’s a shame you don’t have a donate button! I’d certainly donate to this superb blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to new updates and will share this blog with my Facebook group. Talk soon!

  33. June 14th, 2013 at 11:01 | #33

    Have you ever considered about including a little bit more than just your articles? I mean, what you say is valuable and everything. But just imagine if you added some great graphics or videos to give your posts more, “pop”! Your content is excellent but with images and clips, this site could certainly be one of the very best in its field. Superb blog!

  34. June 15th, 2013 at 03:46 | #34

    A person necessarily assistance to make critically posts I’d state. That’s the very first time I frequented your net page and to this point? I amazed together with the analysis you created to create this actual submit unbelievable. Great process!

  35. June 15th, 2013 at 04:34 | #35

    Everyone loves what you guys are usually up too. This sort of clever work and reporting! Keep up the great works guys I’ve you guys to blogroll.

  36. June 15th, 2013 at 05:32 | #36

    Hello! I know this is kinda off topic however , I’d figured I’d ask. Would you be interested in trading links or maybe guest writing a blog post or vice-versa? My site covers a lot of the same topics as yours and I think we could greatly benefit from each other. If you happen to be interested feel free to send me an e-mail. I look forward to hearing from you! Wonderful blog by the way!

  37. June 15th, 2013 at 08:58 | #37

    My partner and I absolutely love your blog and find almost all of your post’s to be exactly what I’m looking for. can you offer guest writers to write content for you personally? I wouldn’t mind writing a post or elaborating on some of the subjects you write related to here. Again, awesome weblog!

  38. June 16th, 2013 at 02:47 | #38

    Hey there! I just wanted to ask if you ever have any problems with hackers? My last blog (wordpress) was hacked and I ended up losing months of hard work due to no backup. Do you have any methods to protect against hackers?

  39. June 16th, 2013 at 04:12 | #39

    Hi! I could have sworn I’ve been to this site before but after checking through some of the post I realized it’s new to me. Nonetheless, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!

  40. June 16th, 2013 at 05:36 | #40

    Hey there! This is my first comment here so I just wanted to give a quick shout out and say I truly enjoy reading through your blog posts. Can you recommend any other blogs/websites/forums that deal with the same topics? Thanks a lot!

  41. June 17th, 2013 at 06:33 | #41

    Thank you for another wonderful article. Where else could anyone get that type of info in such an ideal way of writing? I’ve a presentation next week, and I am on the look for such information.

  42. June 17th, 2013 at 18:39 | #42

    My programmer is trying to convince me to move to .net from PHP. I have always disliked the idea because of the costs. But he’s tryiong none the less. I’ve been using Movable-type on a number of websites for about a year and am concerned about switching to another platform. I have heard very good things about blogengine.net. Is there a way I can import all my wordpress posts into it? Any kind of help would be greatly appreciated!

  43. June 17th, 2013 at 21:36 | #43

    Everyone loves what you guys are up too. This kind of clever work and coverage! Keep up the awesome works guys I’ve included you guys to my own blogroll.

  44. June 18th, 2013 at 03:05 | #44

    Thanks for your post. Another thing is that being photographer will involve not only difficulty in catching award-winning photographs and also hardships in acquiring the best video camera suited to your requirements and most especially issues in maintaining the quality of your camera. This can be very correct and obvious for those photography addicts that are in to capturing the actual nature’s engaging scenes : the mountains, the particular forests, the actual wild or the seas. Going to these amazing places surely requires a camera that can surpass the wild’s severe setting.

Comment pages
  1. No trackbacks yet.