Database
Monitor Oracle Data Pump Resumable Waits with DBA_RESUMABLE
Mar 4, 2026 / · 11 min read · oracle database data-pump impdp dba-resumable oracle-admin import-export space-management dba_resumable v$session_wait dbms_resumable ·Monitor Oracle Data Pump Resumable Waits with DBA_RESUMABLE When you run a large Oracle Data Pump import (impdp), the job can fail mid-way if a tablespace runs out of space. Oracle's resumable import feature prevents this by suspending the job instead of failing it, giving you time to fix the problem and then letting …
Read MoreOracle exp/imp Parameter File: Direct Path User-to-User Data Migration Moving two schemas from one database to another with the original exp and imp tools means typing a long list of options twice, once per tool. A parameter file (parfile) keeps those options in one place, so the same run can be repeated and checked …
Read MoreOracle Export and Import via Gzip Named Pipe
Mar 1, 2026 / · 5 min read · oracle database backup compression unix dba export-import shell-scripting ·Oracle Database Export and Import to Gzip Through a Named Pipe When you need to export a large Oracle database but do not have enough disk space for a full uncompressed dump file, piping the export directly through gzip using a Unix named pipe is a proven technique. This method compresses data on the fly, producing a …
Read MoreOracle Statspack Installation Guide: spcreate Setup
Sep 5, 2025 / · 8 min read · oracle database performance monitoring administration dba statspack tuning dbms_job dba_jobs ·Oracle Database Statspack Installation Guide - Complete Setup and Configuration Purpose Statspack is a snapshot-based way to see what an Oracle database did between two points in time. AWR is the better-known alternative, and the license position differs. Oracle's Licensing Information guide lists the Automatic …
Read MoreOracle Statspack Snapshot Levels: statspack.snap Guide
Sep 1, 2025 / · 3 min read · Oracle Statspack Performance DBA Monitoring Database Administration Tuning ·Oracle Statspack Snapshot Levels: Complete Guide to Database Performance Monitoring Oracle Statspack snapshots are essential tools for database performance monitoring that capture system statistics at different granularity levels. Understanding how to properly execute snapshots and choose appropriate levels is crucial …
Read MoreMonitoring PGA Usage by Username in Oracle Database Purpose V$SESSTAT is the view that holds one statistic value per session, and two of its statistics describe how much Program Global Area (PGA) memory a session uses right now and the most it has used. The script below joins V$SESSTAT to V$STATNAME, filters the …
Read MoreOracle SGA Breakdown Script Using v$sgastat
Aug 20, 2025 / · 3 min read · oracle database dba performance sql tuning scripts memory management v$sgastat ·Oracle Database SGA Breakdown Script for Performance Monitoring Monitoring memory usage in an Oracle Database is one of the most important tasks for a DBA. The System Global Area (SGA) plays a crucial role in the performance of the database, as it stores data and control information used by Oracle processes. In this …
Read MoreOracle Database: Find Query Hash Value Using V$SQLAREA
Aug 7, 2025 / · 4 min read · oracle database sql performance monitoring dba scripts tuning v$sqlarea ·Oracle Database: Find Query Hash Value Using V$SQLAREA Finding specific SQL queries in Oracle Database can be challenging when dealing with large systems running thousands of statements. This guide demonstrates how to efficiently locate query hash values using the V$SQLAREA system view by searching for unique text …
Read MoreOracle Autotrace Commands: SQL Execution Plan Analysis
Aug 5, 2025 / · 4 min read · oracle database performance tuning sql optimization autotrace execution plan database administration query analysis autotrace ·Oracle Database Autotrace Commands: Complete Guide to SQL Execution Plan Analysis Oracle Database's autotrace feature is a powerful built-in tool that enables database administrators and developers to analyze SQL statement performance by displaying execution plans and runtime statistics. This comprehensive guide covers …
Read MoreOracle: Find Tables with Outdated Statistics via DBA_TABLES
Jul 1, 2025 / · 3 min read · dba_tables oracle database dba statistics performance monitoring sql tuning dbms_output ·Oracle Database Query: Find Tables with Outdated Statistics Purpose This Oracle Database query helps database administrators monitor the progress of table statistics collection by identifying tables that have analyze dates older than the current date. It's particularly useful when running large-scale ANALYZE operations …
Read More