Re: shared pool latch time out exceeding 40% HELP!!!

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 2 May 1999 15:02:12 +0100
Message-ID: <925653865.26944.2.nnrp-13.9e984b29@news.demon.co.uk>

Or, to put it another way,
the shared pool can be TOO big.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Kevin Brand wrote in message <7ghlq3$adt$1_at_news.gte.com>...
>
>Do you have the same problem just after instance start-up?
>
>If you do not, then you may be experiencing shared_pool free list
>fragmentation, which can cause really bad latch contention and subsequently
>slow response across the board.
>
>Try flushing the shared pool when you have lots of contention as a test.
If
>contention goes down suddenly, then you do have this condition.
Received on Sun May 02 1999 - 09:02:12 CDT