Script
文章平均质量分 68
Honcho
Love Life Love Oracle !
展开
-
Monitor Data Guard Log Shipping
Note: This query needs to be run on the Primary database. SET PAGESIZE 124 COL DB_NAME FORMAT A8 COL HOSTNAME FORMAT A12 COL LOG_ARCHIVE原创 2011-10-18 23:21:18 · 420 阅读 · 0 评论 -
Check RMAN Backup Status
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原创 2011-10-24 23:56:19 · 585 阅读 · 0 评论 -
Locked Sessions and Locked Objects
ROMPT Blocked and Blocker Sessions col blocker_sid format 99999999999 col blocked_sid format 99999999999 col min_blocked format 99999999999 col request format 9999999 select /*+ ORDERED */ block原创 2011-11-05 08:37:27 · 568 阅读 · 0 评论 -
Display Locks and Gives the SID and Serial Number of the session to kill
This script displays locks and gives the SID and Serial Number of the session to kill. REM ------------------------------------------------------------------------ REM PURPOSE: REM The repo原创 2012-01-12 22:16:59 · 413 阅读 · 0 评论