Re: Shared pool latches

From: Paul Drake <bdbafh@xxxxxxxxx>
To: mjalsing@xxxxxxxxx
Date: Wed, 1 Dec 2004 19:24:30 -0500

On Wed, 01 Dec 2004 19:01:55 -0500, Manmohan Jalsingh
<mjalsing@xxxxxxxxx> 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

References:

Shared pool latches
From: Manmohan Jalsingh

Re: Shared pool latches

Other related posts: