Re: v$shared_pool_reserved

In 10g is also sum(kghlunfu) request_failures, so could be the 'bug' in the 9.2.0.4, but you can try to build your own view with the correct value i.e. request_failures = sum(kghlunfu)
If you need view definition from 9.2.0.5 and above, let me know, I can send it to you.

On 11/24/06, Yasin Baskan <yasin.baskan_at_yapikredi.com.tr> wrote:
>
>
>
> In 9.2.0.7 EE in v$fixed_view_definition for v$shared_pool_reserved I
> see SUM (kghlunfu) as request_failures, not AVG. This means the sum of
> request failures from all subpools.
>
> Unfortunately I do not have 9.2.0.4 to take a look.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of jo_holvoet_at_amis.com
> Sent: Friday, November 24, 2006 10:35 AM
> To: oracle-l_at_freelists.org
> Subject: v$shared_pool_reserved
>
>
> Hi all,
>
> 9.2.0.4 non-RAC on Solaris.
>
> In looking at v$shared_pool_reserved, specifically at request_failures,
> I get :
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With
> the Partitioning option JServer Release 9.2.0.4.0 - Production
>
> SQL> select request_failures from v$shared_pool_reserved;
>
> REQUEST_FAILURES
> ----------------
> .5
>
> How can a request only half fail ?
>
> v$fixed_view_definition defines request_failures as :
> avg(x$kghlu.kghlunfu) which of course doens't have to be a whole number;
> it just doesn't make sense to me.
>
> mvg/regards
>
> Jo
>
>
> AMI Semiconductor - "Silicon Solutions for the Real World"
> NOTICE:
> This electronic message contains information that may be confidential or
> privileged. The information is intended for the use of the individual or
> entity named above. If you are not the intended recipient, please be
> aware that any disclosure, copying, distribution or use of the contents
> of this information is prohibited. If you received this electronic
> message in error, please notify the sender and delete the copy you
> received.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma ozel
> ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu
> mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve
> para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina iletmekten
> sorumlu kisi degilseniz, mesaj icerigini ya da eklerini kopyalamayiniz,
> yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji gonderen kisiyi
> derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde ya da eklerinde yer
> alan bilgilerin dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan
> garanti edilmemektedir ve bilinen viruslere karsi kontrolleri yapilmis
> olarak yollanan mesajin sisteminizde yaratabilecegi zararlardan Bankamiz
> sorumlu tutulamaz.
>
> This message and the files attached to it are under the privacy liability
> in accordance with the Banking Law and confidential to the use of the
> individual or entity to whom they are addressed. This message cannot be
> copied, disclosed or sold monetary consideration for any purpose. If you are
> not the intended recipient of this message, you should not copy, distribute,
> disclose or forward the information that exists in the content and in the
> attachments of this message; please notify the sender immediately and delete
> all copies of this message. Our Bank does not warrant the accuracy,
> integrity and currency of the information transmitted with this message.
> This message has been detected for all known computer viruses thence our
> Bank is not liable for the occurrence of any system corruption caused by
> this message
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l