<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
本文作者:biti_rainy(biti_rainy@itpub.net)
摘要:本文通过简单实验来尝试说明 cursor_ sharing= similar的含义。
1.1. 实验现象
我们先看看在表没有分析无统计数据情况下的表现
SQL>altersessionset cursor_ sharing= similar;
Sessionaltered.
SQL>selectname,valuefromv$sysstatwherenamelike'%parse%';
NAME VALUE
--------------------------------------------------------------------------
parsetimecpu 4948
parsetimeelapsed 4468
parsecount(total) 170148
parsecount(hard) 1619 (硬分析次数)
parsecount(failures) 80
SQL>selectcount(*)fromtwhereobject_id=1000;
COUNT(*)
----------
0
SQL>selectname,valuefromv$sysstatwherenamelike'%parse%';
NAME VALUE 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
本文作者:biti_rainy(biti_rainy@itpub.net)
摘要:本文通过简单实验来尝试说明 cursor_ sharing= similar的含义。
1.1. 实验现象
我们先看看在表没有分析无统计数据情况下的表现
SQL>altersessionset cursor_ sharing= similar;
Sessionaltered.
SQL>selectname,valuefromv$sysstatwherenamelike'%parse%';
NAME VALUE
--------------------------------------------------------------------------
parsetimecpu 4948
parsetimeelapsed 4468
parsecount(total) 170148
parsecount(hard) 1619 (硬分析次数)
parsecount(failures) 80
SQL>selectcount(*)fromtwhereobject_id=1000;
COUNT(*)
----------
0
SQL>selectname,valuefromv$sysstatwherenamelike'%parse%';
NAME VALUE 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>