Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shared Pool: Can it be filled *over* 100% ? - OK, it can ...
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