Skip to content
Wednesday, August 13, 2025

DBA Notes

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

Categories

  • AWS (9)
  • Docker (7)
  • General (4)
  • Linux (14)
  • mongodb (1)
  • MySQL (10)
  • notepad++ (2)
  • Oracle (90)
  • performance (45)
  • Postgres (93)
  • postgresql (9)
  • SQL (16)
  • Windows (7)

Month: August 2023

Oracle performance

Oracle Manageability Monitor Process (MMON) Background Process

Bulent Soylu August 5, 2023 memorymmonoracle

Oracle Manageability Monitor Process (MMON) Background Process. Performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing Automatic Database Diagnostic Monitor analysis…

View More Oracle Manageability Monitor Process (MMON) Background Process
Linux Oracle performance

What is the usecase of dev shm

Bulent Soylu August 2, 2023 /dev/shmoracleperformancetmpfs

/dev/shm is a temporary file storage filesystem (see tmpfs) that uses RAM for the storage. It can function as shared memory that facilitates IPC. It is a…

View More What is the usecase of dev shm
Oracle performance

How much memory is truly used by my Oracle instance?

Bulent Soylu August 1, 2023 asmmmemory_targetoracleperformancesga_targetshared pages

There are many posts about the amount of memory that is taken by the Oracle database executables and the database SGA and PGA. The reason…

View More How much memory is truly used by my Oracle instance?

Posts navigation

Previous page Page 1 Page 2 Page 3
Log in

oracle (86)postgres (52)performance (38)postgresql (33)index (11)upgrade (9)linux (9)multitenant (7)pdb (6)partitioning (6)docker (6)windows (5)memory (5)mysql (5)replication (5)execution plan (5)aws (5)sql profiles (4)tuples (4)SQL (4)

Recent Posts

  • PostgreSQLยฎ EXPLAIN โ€“ What are the Query Costs?
  • ๐—ฆ๐—ค๐—Ÿ ๐—ค๐˜‚๐—ฒ๐—ฟ๐˜† ๐—˜๐˜…๐—ฒ๐—ฐ๐˜‚๐˜๐—ถ๐—ผ๐—ป ๐—ข๐—ฟ๐—ฑ๐—ฒ๐—ฟ!
  • TABLE FRAGMENTATION IN ORACLEย DATABASE
  • Configuring Huge Pages for MySQL Server on Red Hat Linux
  • HUGE PAGES AND POSTGRESQL

Archives

  • July 2025 (1)
  • October 2024 (1)
  • August 2024 (1)
  • March 2024 (3)
  • January 2024 (3)
  • December 2023 (7)
  • 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