Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shared pool and library cache latch contention

Re: Shared pool and library cache latch contention

From: Tanel Poder <tanel_at_@peldik.com>
Date: Thu, 13 Mar 2003 17:18:06 +0200
Message-ID: <3e70a079$1_2@news.estpak.ee> 





> Also, when you increased shared pool to 800M, did you inrease

> shared_pool_reserved_sze to 10% of it as well?




You can also query REQUEST_FAILURES from V$SHARED_POOL_RESERVED, to see if
it's too small.



Tanel.
Received on Thu Mar 13 2003 - 09:18:06 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US