Create Directory
Directory objects in Oracle map to physical server paths and are required for file operations like expdp / impdp. 1. Create Physical Directory on…
CATEGORY
Database
Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.
323 articles
SCP File Transfer
As a DBA, you often need to move .dmp, .log, .ctl, .bkp, and .par files between servers during activities like database refresh, cloning, patching,…
Disable Oracle Scheduler Jobs: Job Queue, Memory, SPFILE, RAC, Non-SYS Jobs
Oracle Scheduler automates job execution. Sometimes, you need to disable jobs temporarily or permanently — for maintenance, troubleshooting, or performance reasons. This guide covers…
Start & Stop MRP Process in Oracle Data Guard
MRP applies redo logs on a physical standby to keep it synchronized with primary. Starting/stopping MRP controls redo apply. 1. Verify Standby Role &…
Oracle Manual Switchover (Primary ➝ Standby) – DGMGRL
A switchover is a planned role reversal between a primary and its standby database in a Data Guard configuration. It allows the standby database…
Oracle Access Control Lists (ACLs)
ACLs control fine-grained network access permissions in Oracle, managing which users/roles can connect to or resolve resources. Stored as XML in Oracle XML DB…
Archive Log Generation in Oracle
Monitoring archive log generation is crucial for maintaining database health, planning disk space usage, and ensuring backup efficiency. This post provides practical SQL queries…
Oracle Session Management
An Oracle session represents a single connection from a user or application to the database. Monitoring and managing sessions is key for performance, troubleshooting,…
Oracle Tablespace Management
In Oracle, a tablespace is a logical storage unit — it groups physical datafiles where your actual data lives. Knowing the different types helps…
Clone Oracle User with user_profile.sql Script
📌 What This Script Does: This SQL script generates a full export of an Oracle database user — including their creation statement, profile, password…
Oracle User Management
An Oracle user is an account that can connect to the database and perform operations. Managing users ensures proper access control, security, and organization…
Oracle Database Start and Stop
This quick reference provides clean, consistent commands to start and stop an Oracle Database — for single instance, Oracle Restart, and RAC environments using…