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

In article: <parkerr.5.000EF94A_at_logica.com> parkerr_at_logica.com (Robin Parker) writes:
# >You need to run SYS.DBMS_UTILITIES.KEEP_PACKAGE('package_name');
# >and then compile the package.
#
# >PS - you may need to check the syntax of that statement - I'm doing it from
# >memory and couldn't
# >find the procedure in the DBA Guide! Perhaps someone could jump in and help
# >out?
#
#
# The syntax is :
# execute sys.dbms_shared_pool.keep('user.package_name');
#
# You then need to execute something from the package to load it into memory.
#
# If you declare a global variable in the package you can just assign that
# varaible a value to load the whole package into memory.
#
# i.e.
#
# execute package_name.dummy_variable := 1;
#
# Hope this helps
#
# Robin.
#
#

Aah. Thank you Robin.

The curse of only having a connection from home. I couldn't be bothered to log in at work to check the syntax.

Thanks again for prompting.

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

Cheers

-- 

|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
| PETER  MOORE  | pt_at_chaff.demon.co.uk       | "Either he's dead, or my watch |
|     DBA       |                            |  has stopped!" - Groucho       |
| MAT Transport | +44 (171) 410 6373         |                                |
|_____________________________________________________________________________|