Skip to content
Monday, May 12, 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 (44)
  • Postgres (92)
  • postgresql (8)
  • SQL (16)
  • Windows (7)

Tag: aws rds

AWS Oracle

Alert Log file and Listener Log file in  AWS RDS Oracle

Bulent Soylu January 31, 2024 alert.logaws rdslistener.logoracle

In AWS RDS Oracle we can use Listenerlog and Alertlog data dictionary views to check errors and other related information. in sqlplus you can use…

View More Alert Log file and Listener Log file in  AWS RDS Oracle
AWS Postgres

Scheduling maintenance with the PostgreSQL pg_cron extension

Bulent Soylu August 18, 2023 aws rdspg_cronpostgresql

You can use the PostgreSQL pg_cron extension to schedule maintenance commands within a PostgreSQL database. For more information about the extension, see What is pg_cron? in the pg_cron documentation.…

View More Scheduling maintenance with the PostgreSQL pg_cron extension
Postgres

Amazon AWS upgrades to Postgres with Bucardo

Bulent Soylu August 13, 2023 aws rdsbucardomigrationpostgresqlupgrade

 Amazon Relational Database Service (RDS), allows for quick setup and use of a database system. Despite minimizing many database administration tasks, some issues still exist, one…

View More Amazon AWS upgrades to Postgres with Bucardo
Log in

oracle (86)postgres (51)performance (37)postgresql (32)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

  • 𝗦𝗤𝗟 𝗤𝘂𝗲𝗿𝘆 𝗘𝘅𝗲𝗰𝘂𝘁𝗶𝗼𝗻 𝗢𝗿𝗱𝗲𝗿!
  • TABLE FRAGMENTATION IN ORACLE DATABASE
  • Configuring Huge Pages for MySQL Server on Red Hat Linux
  • HUGE PAGES AND POSTGRESQL
  • How to configure HugePages for Oracle Database Server

Archives

  • 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