Re: Error ORA-04031 "Bamima: Grow Bam Buffer" At Run Time

parkerr_at_logica.com (Robin Parker) wrote:
>> SNIP <
 

>>BTW do you know if DBMS_SHARED_POOL is documented anywhere apart from the Oracle
>>White Paper
>>that I've seen it on?

The package creation script is reasonably well documented (dbmspool.sql in ORACLE_HOME/rdbms/admin on a Unix box).

>I can't recall seeing any other documentation on it, but I think I do remember
>reading somewhere that these utilities may NOT be included in later versions
>of Oracle (but I stand to be corrected). Presumably Oracle would then need to
>provide some other method of pinning which would then be documented in the
>manuals (but then again knowing Oracle .... :) )

Correct. The documentation in the package creation script says that the pacakge may NOT be included if Oracle can work out some way of doing the same thing automatically.

>
>Robin

-- 
 
 
Regards 
 
Pete 
 
========================================================================
Peter Sharman                                      Email: 
psharman_at_au.oracle.com 
Education Consultant                             Phone: +61.62.479.366 
(int'l) 
ORACLE Education				(06)247 9366 (local) 
 
"Controlling application developers is like herding cats." 
Kevin Loney, ORACLE DBA Handbook 
"Oh no it's not!  It's much harder than that!" 
Bruce Pihlamae, long term ORACLE DBA 

select standard_disclaimer, witty_saying from company_requirements;
========================================================================