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版本上试验一下。
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.
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!
you might possess a terrific blog right right here! would you wish to make some invite posts on my weblog?
Friday Night Lights is actually a fantastic television series, i enjoy the game and i enjoy the story::
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
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!
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?
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.
I was examining some of your content on this site and I think this web site is real instructive! Keep on posting.
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!
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!
dress shops that supply discounts are quite prevalent in our location and i constantly shop at them’
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!
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.
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!
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
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.
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!
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!
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!
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?
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!
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.
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!
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.
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.
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!
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.
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
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!
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.
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!
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!
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!
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.
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!
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!
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?
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!
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!
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.
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!
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.
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.