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: Can it be filled *over* 100% ? - OK, it can ...

Re: Shared Pool: Can it be filled *over* 100% ? - OK, it can ...

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Mon, 16 Aug 2004 09:00:21 +0200
Message-ID: <2ob4jtF868ljU1@uni-berlin.de>


Thank You all (except for one "specialist" ...) for Your highly appreciated comments !

I have learned that the formula actually can reach over 100% for the reasons that Jonathan explained. My last attempt to add the reserved size to the sum is obviously meaningless. The Oracle docco also says reserved size is a part of the entire shared pool size. And I read a conformation in Tomsī book "Oracle One-on-One", his example figures also would be calculated to over 100%.

v$sgastat and v$parameter indeed have nothing to _join_ . So, it would _always_ be a cartesian product.

P.S. My ORA-04031 disappered after increasing shared_pool_size from 80M to 100M.
I am still checking about our stored proceduresī code, but luckily in most cases we do _use_ bind variables, and dynamic SQL that hits the boundaries of binding is still rare at this place.

Greetings, Jan Received on Mon Aug 16 2004 - 02:00:21 CDT

Original text of this message

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