Create a file named daily_full_expdp.sh  : ###################################################################### #!/bin/bash # --- Configuration Variables --… Read more »

For more granular control or when you want to execute Data Pump operations directly from SQL*Plus or a PL/SQL block (e.g., within a stored procedure or schedul… Read more »

Prerequisites for expdp: Oracle Directory Object CREATE DIRECTORY data_pump_dir AS '/u01/app/oracle/datapump_backups'; -- Grant to the user performin… Read more »

Find CPU and memory usage of oracle DB server: Below script is useful in getting CPU, memory and core, socket information of a database server from SQL prompt.… Read more »

To start with some of the important tables/views that you should refer to monitor Data Pump Jobs are: DBA_DATAPUMP_JOBS DBA_DATAPUMP_SESSIONS DBA_RESUMABLE V$S… Read more »

Use this script to get a fast overview of the state of a troubled system spool /tmp/snap; prompt**************************************************** prompt Hit… Read more »