Thanks a lot
Francesco
"Claus Østby Nielsen" <cni_at_privat.dk> ha scritto nel messaggio
news:3f464abe$1_at_bg1....
>
> "F.Marchioni" <fmarchioniNIENTESPAM_at_libero.it> wrote:
> >Hi all,
> >I'd like to know what is the impact on my queries
> >when I have
> >a low Library Cache Hit Ratio? maybe all the
> >query that reference
> >objects in the dictionary will slow down ?
> >Thanks a lot
> >Francesco
> >
> >
>
> The impact will be a huge load on the CPU resources as Oracle will have to
> re-parse the sql-statements for each new statement execution. You will
also
> get latch contention. This is a minor problem in a development/low use
environment,
> but will cause major problems in a production environment. The solution is
> to ensure that bind-variables are used by all often referenced statements
>
> Posted via www.My-Newsgroups.com - web to news gateway for usenet access!
>
Received on Wed Aug 27 2003 - 04:36:37 CDT
