• Home
  • Services
  • About
  • Training
  • GoldenGate
  • Resources
  • Log In
  • Log Out
  1. Home
  2. Knowledge Base
  3. Scripts
Searching...

Scripts

  • Performance Tuning

  • Monitoring

  • 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...
Next
© Copyright Gavin Soorma.
  • Home
  • Services
  • About
  • Training
  • GoldenGate
  • Resources
  • Log In
  • Log Out