Tuning the Program Global Area and the User Global Area
In this recipe, we will see the Program Global Area (PGA) and the User Global Area (UGA) and how to tune them for maximum performance.
The PGA is used to store real values of bind variables, sort areas, and cursor state information. In a dedicated server environment this area is in private user memory. Only in a shared-server environment the session stack space remains in the PGA, while session data and cursor state are moved into the shared pool.
How to do it...
The following steps will demonstrate tuning the PGA and UGA:
- Connect to Oracle Enterprise Manager as
SYSDBA. - Go to Advisor Central.
- Choose Memory Advisors.
- Choose the PGA palette to show or change the size of PGA.
- Connect to SQL*Plus as ...
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
