Re: Shared pool latches

From: Paul Drake <bdbafh_at_gmail.com>
Date: Wed, 1 Dec 2004 19:24:30 -0500
Message-ID: <910046b404120116245b05c141@mail.gmail.com>

On Wed, 01 Dec 2004 19:01:55 -0500, Manmohan Jalsingh <mjalsing_at_lycos.com> wrote:
> Hi,
>
> Is there any reason why Oracle is not using all the shared pool latches.
> In one of our database, we have 7 shared pool latches, but only 3 are being
> used. Gets/Imme gets for other shared pool latches are 0.
>
> Thanks.
> Manmohan

what is the size of the shared_pool?
how many CPUs (both physical and logical) exist in the server (domain)? Is this the same operating system and database software version as the other post, which was Oracle 10g / RHEL 3.0 Update 2 / Lintel x86-64?

perhaps you have perfectly written SQL and there is no parsing taking place whatsoever. :)

Paul

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

Received on Wed Dec 01 2004 - 18:22:03 CST