V$DATABASE
Run a Consistent Export with expdp FLASHBACK_TIME
Jul 10, 2026 / · 11 min read · Oracle DBA Data Pump expdp FLASHBACK_TIME Consistent Export Oracle Administration Undo Retention Oracle Backup dba_free_space v$database v$parameter v$undostat ·Run a Consistent Export with expdp FLASHBACK_TIME Purpose A Data Pump export that reads one table at 02:00 and the next at 02:15 is not a consistent snapshot — it is a photograph taken in pieces over time. For schemas where rows in one table reference rows in another, that time spread means the export can capture …
Read MoreOracle: Get Current SCN with DBMS_FLASHBACK
Mar 8, 2026 / · 5 min read · oracle scn flashback dba sql database recovery read consistency admin scripts dba_tab_privs v$database dbms_flashback ·How to Find the Current SCN in Oracle Database Using DBMS_FLASHBACK The System Change Number (SCN) is Oracle's internal logical clock. Every DBA needs to know how to read it. This post shows you the simplest SQL query to get the current SCN from any Oracle Database session, and explains exactly why it matters. What Is …
Read MoreDB_FLASHBACK_RETENTION_TARGET: Set Oracle Flashback Window
Mar 6, 2026 / · 5 min read · Oracle Flashback DBA Recovery Database Administration ALTER SYSTEM Fast Recovery Area Point In Time Recovery v$database ·Set Oracle Flashback Database Retention Target with ALTER SYSTEM Oracle Flashback Database lets you rewind your entire database to a past point in time without a full restore. The command ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET controls how far back in time that rewind can go. What This Command Does The …
Read MoreOracle Flashback: Enable with Shutdown, Mount, ALTER
Mar 5, 2026 / · 6 min read · Oracle Flashback DBA Database-Recovery Oracle-Backup SQL Data-Protection Admin-Guide v$database v$flashback_database_log ·How to Enable Oracle Database Flashback: Shutdown, Mount, and ALTER Commands Oracle Flashback Database is one of the most powerful data protection tools available to a DBA. This guide walks you through the four commands needed to turn on Oracle Flashback — from a clean shutdown to opening the database in flashback …
Read MoreHow to Check Oracle Database Role Using V$DATABASE View
Jan 1, 2026 / · 3 min read · Oracle Data Guard DBA SQL Query Database Administration V$DATABASE Standby Database Primary Database ·How to Check Oracle Database Role Using V$DATABASE View Purpose The SQL query SELECT database_role FROM v$database is a fundamental Oracle Database command used to determine the current operational role of a database instance. This query is essential for Database Administrators (DBAs) working with Oracle Data Guard …
Read MoreOracle Data Guard Standby Database Startup Commands
Oct 23, 2025 / · 6 min read · Oracle Data Guard Standby Database Database Recovery High Availability Backup DBA SQL Commands v$archive_dest_status v$database ·Oracle Data Guard Standby Database Startup Commands Oracle Data Guard standby database startup commands enable database administrators to initialize and maintain physical standby databases that provide disaster recovery and high availability for production systems. These three essential commands work together to bring …
Read MoreOracle Statspack: List Snapshots with stats$snapshot
Sep 4, 2025 / · 3 min read · oracle statspack performance monitoring dba sql snapshots administration v$database ·How to List Oracle Statspack Snapshots with SQL Query This Oracle Database query provides a simple way to view all Statspack snapshots stored in your database. Statspack is Oracle's built-in performance monitoring tool that captures database statistics at regular intervals, helping database administrators analyze …
Read MoreOracle DBA SQL Scripts and Database Commands
Oracle SQL Scripts and Database Commands 23c 21c 19c 18c 12c 11g 10g 9i 8i We are in the process of building a list of simple scripts used every day by DBA and others. If you have your own scripts you reuse in a text file on you workstation please send it to us. To look at other scripts see the Oracle Scripts Tag …
Read More