Database Health Check - Stability Assessment

Related Documents 4
Overview - System Description 5
First Checks 6
  Alert-files and Dump-Destinations 6
    alert.log 6
    userdump-destination 6
    background-dump-destination 6
  User Management 7
  Invalid Objects 7
  Wrong Objects in Schema of SYS or SYSTEM 7
Support 9
Monitoring, Alarming, Troubleshooting, Incident- and Problem Management 10
  Monitoring and Alarming 10
  Incident- and Problem Management 10
Installation 12
  Oracle-BASE compliance 12
  Automatic purging / Lost / Forgotten Files 12
Protection against loss of Data 13
  Backup and Recovery Process 13
    Additional Protections 13
  Protection against Block Level Corruption 14
  Restore 14
Availability 15
  Configuration- and License Limitations 15
    V$RESOURCE_LIMIT 15
    Other License Limitations 16
  Capacity Reserves 16
    Diskspace 16
    Backup Duration 17
    Archivelog Space 17
  Other Availability Features 17
Application Database Objects 18
  Unusual 18
    Disabled Triggers 18
    Disabled Constraints 18
  Tables, Indexes, Data Integrity etc. 18
  Bind Variables 19
  Database Sessions 20
  Statistics 21
  Does the application create temporary tables ? 22