Posts

Sample listener.ora with Static SID_LIST and Extproc Purpose The listener.ora file is the server-side configuration for the Oracle Net listener — the process that accepts incoming client connections and hands them off to a database server process. The sample below — taken straight from the shutdownabort.com DBA Quick …

Delete the 500 Oldest Files in a Directory (Oracle DBA) Purpose Oracle's diagnostic destination (DIAGNOSTIC_DEST), audit file destination (AUDIT_FILE_DEST, also known as adump), and per-process trace directories collect thousands of small files over time. Inode counts, not bytes, are usually the limit that bites first …

List Files Opened by an Oracle Process with lsof -p Purpose lsof (LiSt Open Files) is the UNIX tool for inspecting which processes have which files open. For an Oracle DBA it is the fastest answer to four common questions: which datafiles is this server process touching, which trace file is PMON writing into right now, …

Oracle CREATE DIRECTORY Command Explained The Oracle CREATE DIRECTORY command creates a directory object — a logical alias inside the Oracle database that points to a real folder on the server's file system. This is one of the most used setup steps for Oracle Data Pump exports and imports, UTL_FILE file operations, …

Oracle Data Pump: Create the DATA_PUMP_DIR Directory Before you can run any Oracle Data Pump export (expdp) or import (impdp) job, Oracle needs to know where to write and read dump files and log files on the server. You do this by creating a directory object inside the database that points to a real folder on the …

Oracle Data Pump Export Schema with expdp Command Guide Oracle Data Pump's expdp utility lets you take a fast, flexible logical backup of any schema in your Oracle database. This post breaks down a simple schema-level export command, explains each parameter, and shows you how to run it safely. What This Command Does …

Oracle expdp Schema Export Using Data Pump Oracle Data Pump's expdp utility lets you export a full database schema — including tables, indexes, constraints, and data — into a portable dump file. This guide breaks down the single-line command that does exactly that for the andy schema. Purpose of This Command The goal …

Oracle DBMS_FLASHBACK Enable At Time: Session Flashback Guide Oracle's DBMS_FLASHBACK.ENABLE_AT_TIME is a powerful procedure that lets you travel back in time within your database session — letting you query data exactly as it existed at a specific past moment, without needing a full database restore. What This Code …

Overview When working with Oracle Database, there are times when you need to look at data from the past — like rewinding a video to see what happened earlier. Oracle gives you a tool called Flashback to do this. But once you are done looking at past data, you must turn Flashback off. The command to do that is: 1EXEC …

Oracle Flashback Query: Copy Historical Data Into a New Table Sometimes you need to go back in time and recover data the way it looked at a specific moment — without restoring the full database. Oracle makes this possible with Flashback Query, using the AS OF TIMESTAMP clause to read historical data directly from the …