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. April 18th, 2014 at 18:04 | #1

    Thank you a lot for sharing this with all folks you really understand what you are speaking approximately!
    Bookmarked. Kindly also talk over with my site =). We can have a hyperlink
    trade agreement among us

  2. April 23rd, 2014 at 14:29 | #2

    Buyer power increased sharply when this new option arrived actually had more michael kors handbags Outlet than one company from which to buy CPUs! Besides the michael kors bags Outlet design equation is more muddled on the Windows laptop front so it more interesting as an exercise. A lot of the time, depending on the note, the vowels are modified so that Michael Kors Outlet the sound resonates in a pleasing manner. Fifth, a bag of tea leavesIt is necessary for women to drink tea. What exacty is

  3. April 24th, 2014 at 18:02 | #3

    zugleich – ein Fest von Essen, Wein und Hausmannskost. Erleben Sie den Charme der Bricktown HotelThe Bricktown Hotel & Convention Center in einem charmanten historischen Viertel von Oklahoma City bietet große Gastfreundschaft und Luxus zu erschwinglichen Preisen zur Verfügung. Es ist nur 1,converse,5 Meilen vom Herzen des Vergnügungsviertels von Bricktown und auch in unmittelbarer Nähe zu den anderen Sehenswürdigkeiten der Innenstadt von Oklahoma City. Die breite Pa

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