Honcho’s Oracle Blog

Note: This query needs to be run on the Primary database.SET PAGESIZE 124COL DB_NAME FORMAT A8COL HOSTNAME FORMAT A12COL LOG_ARCHIVE

Scripts to check backup status and timings of database backups -This script will be run in the database, not the catalog. Login as sysdba -This script will report on all backups – full, increm

ROMPT Blocked and Blocker Sessionscol blocker_sid format 99999999999col blocked_sid format 99999999999col min_blocked format 99999999999col request format 9999999select /*+ ORDERED */block

This script displays locks and gives the SID and Serial Number of the session to kill. REM ------------------------------------------------------------------------ REM PURPOSE: REM    The repo