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: linux

Linux

Find Top Running Processes by Memory and CPU Usage

Bulent Soylu August 11, 2023 cpulinuxmemoryram

1. top command The top command gives real-time information about the running processes as well as a summary of system information. It displays uptime, load averages, CPU…

View More Find Top Running Processes by Memory and CPU Usage
Linux

How to troubleshoot high memory usage in linux

Bulent Soylu August 11, 2023 linuxmemory

There are situations where your server shows unintended behaviors like a slow response from websites, failures with services, inability to start applications, server crashes etc.…

View More How to troubleshoot high memory usage in linux
Linux performance SQL

Understanding IOPS vs. throughput

Bulent Soylu January 9, 2023 linuxoracleperformance

Input/output operations per second (IOPS) and data throughput are two popular performance characteristics of any storage system. In the early days of computer technology, when…

View More Understanding IOPS vs. throughput
Linux MySQL

MySQL login root without password in Linux

Bulent Soylu March 2, 2022 linuxmysql

to add more users just add more user and password in ~/.my.cnf

View More MySQL login root without password in Linux
Linux

How to Configure Virtual IP Address (VIP) on CentOS

Bulent Soylu January 27, 2022 centoslinuxvirtual ip

As its name suggests, Virtual IP address (VIP) is an IP address that doesn’t have an actual physical network interface. Incoming packets are sent to…

View More How to Configure Virtual IP Address (VIP) on CentOS
Linux Postgres

Adding postgres as SUDOERS in centos

Bulent Soylu January 18, 2022 linuxpostgressudoers

Login as root: :wq!

View More Adding postgres as SUDOERS in centos
Linux

How to Configure and Use PAM in Linux

Bulent Soylu November 26, 2021 linuxpam

Linux-PAM (short for Pluggable Authentication Modules which evolved from the Unix-PAM architecture) is a powerful suite of shared libraries used to dynamically authenticate a user to applications (or…

View More How to Configure and Use PAM in Linux
Docker Linux Postgres

Docker linux add sudoers, alias commit image

Bulent Soylu October 9, 2021 No Comments aliasdockerdocker commitimagelinuxsudoervim

at docker cli with root user: #apt-get install sudo #usermod -aG sudo postgres #su – postgres postgres # sudo whoami Permanent Alias vim ~/.bashrc or…

View More Docker linux add sudoers, alias commit image
General Linux

RHEL 8 / CentOS 8 firewall commands

Bulent Soylu September 27, 2021 No Comments centos8firewalllinuxrhel8

systemctl status firewalld systemctl stop firewalld systemctl disable firewalld systemctl start firewalld systemctl enable firewalld

View More RHEL 8 / CentOS 8 firewall commands
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