Customer Support Language
 
HomeKnowledge BaseCampaignMaxSetting PGA work area in Oracle 9i
Information
Article ID74
Created On6/24/2004
Modified9/11/2008
Share With Others
Setting PGA work area in Oracle 9i
The Process Global Area (PGA) is a critical memory that can severly impact Oracle performance. MetaLink article 223730.1 contains info on configuring the size of the PGA and determining the recommended size base on Oracle utilization.

Article 148511.1 discusses the DB_CACHE_ADVICE settings.