Üretim ortamlarındaki tecrübeler, execution plan çözümlemeleri, veritabanı mimarisi, yedekleme ve felaket kurtarma senaryoları.
Veri kaybına tahammülü olmayan kurumsal sistemlerde RPO ve RTO matematiği, PITR, WAL arşivleme, senkron replikasyon ve test edilmiş felaket kurtarma senaryoları.
Yavaş çalışan SQL sorgularını analiz etme, execution planları doğru okuma, Shared Buffers maliyetleri ve modern PostgreSQL index mimarileri üzerine kapsamlı DBA rehberi.
Oracle RMAN → Azure Blob Backup to Azure, the clean way Minimal steps, Oracle JDK only, and the recommended oracle.azure library alias. What you’ll need...
Oracle Auto-Startup via Cron Use one of these two options to have both your primary and standby databases come up automatically on reboot. Paste the entire...
Systemd ile yönetilen PostgreSQL servislerinde veri dizinini (data directory) güvenli bir şekilde farklı bir diske veya dizine taşıma.
PostgreSQL DBA'leri için VACUUM, ANALYZE, REINDEX ve tablo şişmesi (bloat) yönetimini içeren hızlı başvuru rehberi.
PostgreSQL Restore Commands Reference This guide covers the three primary methods to restore PostgreSQL data: using psql for plain‐text dumps, pg_restore...
PostgreSQL pg_dump, pg_dumpall ve pg_restore komutları ile şema, tablo ve veri yedekleme pratik komut referansı.
Rescuing a Dropped PostgreSQL Database: Two pgBackRest Paths to Success That sinking feeling when a DROP DATABASE command slips through... we've all been...
PostgreSQL Cluster Control Cheat-Sheet 1 · What Exactly Is a “Cluster”? In PostgreSQL terminology, a cluster is a self-contained instance: one data...
PostgreSQL 16 Server Configuration & Tuning Cheatsheet 1 · Parameter Fundamentals Case-insensitive names. Value types: boolean · integer · float · string ·...
PostgreSQL 16 Data Dictionary & Catalog Cheat-Sheet PostgreSQL ships with a rich “data dictionary” — a collection of catalog tables , views and utility...
Fixing perl(IPC::Run) Dependency Error When Installing PostgreSQL 17 on Oracle Linux 8 Background While preparing a fresh Oracle Linux 8 server for a...
psql Cheat-Sheet & Power User Guide 1 · Startup Sequence Environment – PGHOST , PGPORT , PGUSER , PGDATABASE are honoured. User profile – reads...
PostgreSQL Reference Guide General Database Limits Maximum Database Size: Unlimited Maximum Table Size: 32 TB Maximum Row Size: 1.6 TB Maximum Field Size: 1...
PostgreSQL 16 Enterprise‑Grade Installation Guide RHEL 8/9 Edition 1 · Preparation Checklist 64‑bit RHEL 8/9 minimal install, fully patched. Dedicated LVM...
Oracle 19c Physical Standby Creation & Management (RMAN Duplicate + Data Guard Broker) This article walks through building a physical standby using RMAN...
Cloning MYDBPROD → MYDBTEST with RMAN DUPLICATE Sometimes we need a quick, up‑to‑date copy of production for troubleshooting or functional testing. The...
Consolidating Oracle 19c Datafiles & Redo Logs onto a Single Drive Contents 0 · Executive Summary 1 · Pre‑Start Requirements 2 · Inventory & Duplicate‑Name...
Oracle expdp Export Job Script This bash script runs an Oracle Data Pump export (expdp) job with anonymized parameters (except the expdp binary path)....
This guide provides a suite of T‑SQL queries that give you a quick snapshot of your SQL Server’s health. The toolkit covers: Database Health Status Top 5...
When an Oracle database user account expires, it needs to be unlocked and assigned to a profile that ensures password expiration does not occur. Follow...
Oracle 11gR2 üzerinde kullanıcı veya sistem veri kütüklerini (datafiles) kontrol dosyası ile senkron şekilde yeni bir dizine taşıma rehberi.
Practical RMAN Restore Guide This guide shows how to restore and relocate an Oracle database via RMAN. We’ll assume you want all datafiles in a new folder (...
Learn how to execute a SQL query via SQL Server Agent using PowerShell and sqlcmd . This method ensures UTF-8 compatibility and proper handling of...
PostgreSQL pg_cron: Scheduling Materialized View Refresh Across Databases In this tutorial, I’ll walk you through the process of scheduling a Materialized...
The SYSAUX tablespace might fill up with records from advisor tasks. Use the following steps to identify and resolve the issue. Step 1: Check SYSAUX Usage...
Oracle 19c Data Guard mimarisinde planlı bakım ve veri merkezi geçişleri için sıfır veri kayıplı Switchover rehberi.
Oracle 19c Data Guard ortamlarında felaket anında standby veritabanını primary moda geçirme (Failover) operasyon adımları.
1. Identify Large Segments in the SYSTEM Tablespace Before deleting records, you may want to identify which segments occupy the most space in the SYSTEM...
Oracle veritabanlarında memory_target, SGA ve PGA bellek parametrelerinin incelenmesi ve dinamik olarak ayarlanması adımları.
The following steps can be used to quickly reconfigure a corrupted standby database in Oracle Data Guard. These steps assume the configurations are already...
How to partition an existing large table in PostgreSQL with range partitioning, automated partition creation, and indexing.
The query below shows what tablespaces does user have files and what are the total sizes of their objects in there.
How to reset or unexpire an Oracle database user password without knowing or changing the current password.
To install the Oracle Database Client with the necessary patches, follow the steps below: 1. Install Pre-requisite RPM You might need to install some...
Common Oracle RMAN backup and disaster recovery scenarios: compressed full backup, missing datafiles, and lost control files.
Steps and status checking queries to recover disconnected and unrecoverable standby databases in Oracle Data Guard.
Step-by-step setup and configuration guide for Oracle Database Gateway for SQL Server (dg4msql) on Linux.
Using the at Command for Scheduled Maintenance We may need some maintenance works for our database systems. If we don't want to spend our evening with all...
A step-by-step guide to setting up streaming replication in PostgreSQL on Linux servers, including configuration, backup automation, and replication monitoring.
How to automate batch procedures in Python by orchestrating functions with argument tuples in a loop.
Normally, you can't restore a single database from a cluster backup that are taken via pg_dumpall.In order to achieve that, you can follow the steps below:...
Oracle SQL Tuning Advisor (STA) ile sorgu optimizasyon görevleri oluşturma, çalıştırma ve silme adımları.
Practical query optimization tips for Oracle Database, including REGEXP_LIKE and table collection functions.
Sometimes if the base object of a synonym is dropped without dropping the synonym, ORA-00980 error may occur. Here is how to detect broken synonyms.
A Python script for RHEL, CentOS, and Oracle Enterprise Linux to alert administrators when a newly installed kernel hasn't been activated by a reboot.
Initial Steps Summary Let’s sum up the initial steps, then dive into key points: Ensure that the primary and replica servers have proper firewall...
Oracle veritabanında UNUSABLE durumdaki indeksleri tespit eden ve otomatik olarak REBUILD eden pratik SQL scripti.
Sometimes in production servers, you might need to check specific record(s) in order get older versions. Oracle has Flashback technology to revert your...
When we need to connect somewhere via cron job, batch script etc. , .pgpass file can be really useful for authorization. Connection information is saved...
How to run long-running shell scripts in the background and redirect output to a log file using nohup and disown.
Sometimes we may need to find some similar data (not exact one) regarding to our needs. For example, one digit of the phone number may have been registered...
Sometimes dummy and hard-coded vales might be needed for testing or some other purposes. We can return single rows easily with 'select ...... from dual'....
It could be tricky to detect when your database slows down for no reason. At first, you should check system resources (CPU - RAM usage, network etc.) and if...
In general, people find dumping their whole databases in sever by pg_dumpall easily. But it takes too long since this tool is not utilized for using...
1. Check Required Packages Ensure the yum packages openssl and pigz are installed on your system. 2. Compress and Encrypt Files Use the following command to...
Step-by-step guide for configuring a virtual IP (VIP) for PostgreSQL on Oracle Enterprise Linux 8 (OEL8).
Follow these steps to upgrade an Oracle Database using the OPatch tool: 1. Download and Prepare Files Download the patch you want to install along with the...
How to migrate PostgreSQL database password authentication from MD5 to SCRAM-SHA-256 securely.
Upgrading PostgreSQL can be a smooth process if you follow the necessary steps carefully. Below is a comprehensive guide to help you through the upgrade....
Arama kriterlerinize veya seçilen etikete uygun makale bulunamadı.