| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: PGA question
Presumably they affect some of the required memory structures - shouldn't be too hard to work out I would have thought. Just measure the pga usage via sesstat and play with the parameters to see the impact
hth
connor
I'm looking through the documentation regarding the PGA. It doesn't say specifically how the following parms affect the size of the PGA, just that it does:
OPEN_LINKS
DB_FILES
LOG_FILES - Obsolete w/8i
On Metalink they just say "this is proprietary". I'm curious - does anyone know? I'm non-MTS, 8.1.7 W2K and AIX (kinda - I can at least look at it & compare...)
db_files is defaulting to 4000 on w2k and it's set to 1021 on the AIX instances for some reason.
Thanks
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117
Fax: 954-935-3639
Cell: 954-683-4459
"The sender believes that this E-Mail and any
attachments were free of any virus, worm, Trojan
horse, and/or malicious code when sent. This message
and its attachments could have been infected during
transmission. By reading the message and opening any
attachments, the recipient accepts full responsibility
for taking proactive and remedial action about viruses
and other defects. The sender's business entity is not
liable for any loss or damage arising in any way from
this message or its attachments."
--Please see the official ORACLE-L FAQ:
http://www.orafaq.net--Author: Koivu, Lisa INET:
Lisa.Koivu_at_efairfield.comFat City Network Services
-- 858-538-5051 http://www.fatcity.comSan Diego,
California -- Mailing list and web hosting
services---------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Feb 27 2003 - 18:58:46 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |