Introduction
To detect block corruption within Oracle, RMAN is the tool I have typically used to do this. While performing backups or as part of a VALIDATE command, it can check for both physical and logical corruption. In both cases, it stores the corrupted blocks information in the V$DATABASE_BLOCK_CORRUPTION object. This view can be utilized from a DPA custom alert to check for corruption.
Custom Alert
Within DPA, create a Custom SQL Multiple Numeric alert, paste in the attached SQL statement and make it look similar to this:
