Tracking ASM Metrics

Collecting ASM IO Metrics If you are an Oracle DBA, then it is quite likely that Oracle ASM is used as the storage management for at least some of the databases you manage. Eventually you will want to see ASM metrics that can be used to track the performance of the storage over time.  There…

Proactive FRA Monitoring Using OEM Metrics

As you know, thresholds for flash/fast recovery area (FRA) usage are set internally in a database to 85 and 97 per cent, and there are no ways to change the thresholds — at least none that are supported by Oracle. This might work fine in most cases, but being aware of changes in FRA usage can sometimes be helpful. You can then contact your DBA and suggest verifying your database’s settings.