IT World

RDBMS, Unix and many more…

Home
About
Privacy

Program Global Area (PGA)

PGA and SGA sizing

Posted on July 13, 2010, updated on January 26, 2016 by Yannick Jaquier

Table of contents

Preamble
PGA used by processes
How to increase PGA per process
References

Continue reading

Oracle Automatic Shared Memory Management (ASMM), Program Global Area (PGA), System Global Area (SGA) Leave a comment

Search

Certifications

Tags Cloud

11gR2 (9) 12cR1 (6) Active Session History (ASH) (1) Adaptive Cursor Sharing (ACS) (2) Administration (16) Automatic Data Optimization (ADO) (1) Automatic Diagnostic Repository (ADR) (1) Automatic Memory Management (AMM) (2) Automatic Segment Space Management (ASSM) (1) Automatic Shared Memory Management (ASMM) (4) Automatic Storage Management (ASM) (2) Automatic Workload Repository (AWR) (3) Backup (5) Benchmark (7) Cloud Control (2) cluster (1) Compression (3) Connection Manager (1) Database Links (1) Database Resource Manager (DBRM) (3) Database Vault (2) Data Guard (7) Data Recovery Advisor (2) Data Redaction (1) Directory Naming (3) Docker (4) Fast Recovery Area (FRA) (1) Fine-Grained Access Control (FGAC) (1) Flashback (1) GATHER_STATS_JOB (1) GoldenGate (2) Grid Control (4) Grub (1) Health Monitor (1) Heat Map (1) High Availability (15) HP Integrity Virtual Machines (HPVM) (1) Huge Pages (2) Information Lifecycle Management (ILM) (1) InnoDB (2) Instance Caging (1) Multi-Master Replication Manager (MMM) (1) Non-Uniform Memory Access (NUMA) (3) OpenStack (2) OpenView Performance Agent (OVPA) (1) Oracle Configuration Manager (OCM) (1) Oracle Label Security (OLS) (1) oradebug (1) Patch (2) PL/SQL (1) Process Resource Management (PRM) (2) Program Global Area (PGA) (1) Real Application Clusters (RAC) (4) Real Application Testing (RAT) (1) Recovery (2) Redo Log (2) RMAN (5) Security (16) Segment Advisor (2) Single Client Access Name (SCAN) (1) SQL (20) SQL*Net (3) SQL*Plus (1) SQL Access Advisor (SAA) (2) SQL Monitoring (1) SQL Performance Analyzer (SPA) (1) SQL Plan Management (SPM) (1) SQL Profile (1) SQL Trace (1) SQL Tuning Advisor (STA) (5) SQL Tuning Set (STS) (1) Streams (3) System Global Area (SGA) (1) Tivoli Data Protection for Oracle (TDPO) (2) Tivoli Storage Manager (TSM) (1) Transparent Application Failover (TAF) (1) Transparent Data Encryption (TDE) (1) Tuning (35) Virtualization (2) Virtual Memory (2) Virtual Private Database (VPD) (2) VxDMP (1) VxFS (1) VxVM (1)

Categories

AIX (2)
Couchbase (2)
HPUX (6)
Linux (24)
mongoDB (1)
MySQL (29)
Oracle (113)
SQL Server (3)

Recent Comments

Couchbase server as a Memcached cluster (part 1) on Linux Huge Pages and virtual memory (VM) tuning
Pacemaker configuration for an Oracle database and its listener on UDEV to replace ASMLib on Red Hat 7 and OEL 7 for ASM configuration
Yannick Jaquier on GoldenGate 12c (12.2) installation and configuration
Yannick Jaquier on GoldenGate 12c (12.2) installation and configuration
rehan on GoldenGate 12c (12.2) installation and configuration

Blogroll

Ask Tom
Data Virtualizer
dbaStreet
Exile on Keyboard St. (French)
Kevin Closson’s Oracle Blog
MySQL Performance Blog
Official Pythian Blog
Oracle Optimizer
Oracle Scratchpad
Richard Foote’s Oracle Blog
Tanel Poder's blog
The Oracle Instructor

Visitors

Meta

Log in
Entries RSS
Comments RSS
WordPress.org

IT World Proudly powered by WordPress