ASH and AWR Performance Tuning Scripts Listed below are some SQL queries which I find particularly useful for performance tuning. These are based on the Active...
DBUPGDIAG script to check integrity of database before 11g upgrade Script to check integrity of a 9i or 10g database before upgrade to 11g. Run this script connected as sysdba...
Script – Check RMAN Backup Status Scripts to check backup status and timings of database backups – This script will be run in the database, not...
Script – Sessions with high physical reads set linesize 120 col os_user format a10 col username format a15 col pid format 9999999999 PROMPT SESSIONS SORTED BY PHYSICAL...
Script – Database structure and file location set pagesize 500 set linesize 130 Prompt Prompt Control Files Location >>>> col name format a60 heading "Control Files" select...