I just stumbled upon the “Automatic PGA Memory Management” section of
the 9i docs. I’ve never heard of
this before. Does anyone know how
long it’s been around? Anyone
using it found any bugs, concerns, etc.? Granted, this is intended for *dedicated* server mode, it seems
like a good option for our Test databases and perhaps other databases that have
only a handful of users and don’t require MTS. By setting PGA_AGGREGATE_TARGET=X, where X can be a value in
K, M, or G, Oracle will automatically distribute this memory allocation to
dedicated sessions instead of using SORT_AREA_SIZE. Here’s an excerpt from the docs: “Oracle does
not recommend using the Learn something
new every day in Oracle land… david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency
Parkway, Suite 110 Cary, NC
27511-8582 Tel. (919)
466-6723 Fax (919)
466-6783 Mobile (919)
225-4962 [EMAIL PROTECTED]
http://www.arsenaldigital.com/
*** NOTICE *** This e-mail
message is confidential, intended only for the named recipient(s) above and may
contain information that is privileged, work product or exempt from disclosure
under applicable law. If you have
received this message in error, or are not the named recipient(s), please
immediately notify the sender by phone or email and delete this e-mail message
from your computer. Thank you. |