Portal
Language
 
Home>Knowledge Base>Root>CampaignMax>Setting PGA work area in Oracle 9i
User Login
Username
Password
 
 Login
Information
Article ID74
Created On6/24/2004
Modified9/11/2008

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.