Skip to content
Sunday, December 10, 2023

DBA Notes

DBA Notes
  • AWS
  • Oracle
  • Postgres
  • Linux
  • Docker
  • MySQL
DBA Notes

Categories

  • AWS (7)
  • Docker (7)
  • General (3)
  • Linux (12)
  • MySQL (9)
  • notepad++ (2)
  • Oracle (85)
  • performance (38)
  • Postgres (86)
  • postgresql (2)
  • SQL (14)
  • Windows (7)

Tag: pga_aggregate_target

Oracle performance

MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET

Bulent Soylu July 11, 2023 memory_targetpga_aggregate_targetsga_target

The memory structures that must be managed are the system global area (SGA) and the instance program global area (instance PGA). Oracle Database supports various…

View More MEMORY_TARGET, SGA_TARGET and PGA_AGGREGATE_TARGET
Log in

oracle (83)postgres (50)performance (34)postgresql (26)index (10)linux (9)upgrade (9)multitenant (7)docker (6)partitioning (6)pdb (6)windows (5)memory (5)aws (4)execution plan (4)SQL (4)tuples (4)replication (4)mysql (4)sql profiles (4)

Recent Posts

  • Cloning a PDB with Encrypted Data in a CDB
  • Setup Unified auditing in Oracle 19c
  • Creating a Pluggable Database Release 19
  • Setup TDE Encryption In Oracle 19c Database
  • Unplug and Plugin Pluggable database (PDB)

Archives

  • October 2023 (17)
  • September 2023 (6)
  • August 2023 (23)
  • July 2023 (10)
  • June 2023 (4)
  • May 2023 (11)
  • April 2023 (15)
  • March 2023 (6)
  • February 2023 (2)
  • January 2023 (11)
  • December 2022 (1)
  • August 2022 (3)
  • March 2022 (10)
  • February 2022 (2)
  • January 2022 (6)
  • December 2021 (3)
  • November 2021 (7)
  • October 2021 (51)
  • September 2021 (4)

DBA Notes | Designed by: Theme Freesia | WordPress | © Copyright All right reserved