Set the registry value associated with the Advisory to False
Registry Settings for Oracle Advisories
| Advisory name | Severity | Category | Schedule | Registry value |
|---|---|---|---|---|
| Application Wait Deviation | Low | Review Performance Deviations | Every hour | DBO-ApplicationWaitDeviationAdvisoryEnabled |
| CPU Usage Deviation | Low | Review Performance Deviations | Every hour | DBO-CPUUsageDeviationAdvisoryEnabled |
| Cluster Wait Deviation | Low | Review Performance Deviations | Every hour | DBO-ClusterWaitDeviationAdvisoryEnabled |
| Commit Wait Deviation | Low | Review Performance Deviations | Every hour | DBO-CommitWaitDeviationAdvisoryEnabled |
| Concurrency Wait Deviation | Low | Review Performance Deviations | Every hour | DBO-ConcurrencyWaitDeviationAdvisoryEnabled |
| Network Wait Deviation | Low | Review Performance Deviations | Every hour | DBO-NetworkWaitDeviationAdvisoryEnabled |
| Other Wait Deviation | Low | Review Performance Deviations | Every hour | DBO-OtherWaitDeviationAdvisoryEnabled |
| Unbalanced Cluster Workload Distribution | Medium | Address Resource Bottlenecks | Every hour | DBO-UnbalancedClusterWorkloadDistributionAdvisoryEnabled |
| Undo Size | Medium | Address Performance Bottlenecks | Every hour | DBO-UndoSizeAdvisoryEnabled |
| User IO Usage Deviation | Medium | Review Performance Deviations | Every hour | DBO-UserIOUsageDeviationAdvisoryEnabled |
| Workload Deviation | Low | Review Performance Deviations | Every hour | DBO-WorkloadDeviationAdvisoryEnabled |
Registry Settings for SQL Server Advisories
| Advisory name | Category | Schedule |
|---|---|---|
| Buffer Latch Contention | Reduce Contention | 1 hour |
| CLR Wait Deviation | Review Performance Deviations | 1 hour |
| CPU Usage Deviation | Review Performance Deviations | 1 hour |
| Deadlock Observed | Reduce Contention | 1 hour |
| Excessive I/O Wait | Reduce Read/Write operations | 1 hour |
| Excessive Log Wait | Address Resource Bottlenecks | 1 hour |
| Excessive Memory Pressure | Address Resource Bottlenecks | 1 hour |
| Excessive Statements Re-Compiles | Optimize Application Workload | 1 hour |
| I/O Usage Deviation | Review Performance Deviations | 1 hour |
| IO Usage Deviation | Review Performance Deviations | 1 hour |
| Latch Wait Deviation | Review Performance Deviations | 1 hour |
| Lock Wait Deviation | Review Performance Deviations | 1 hour |
| Log Wait Deviation | Review Performance Deviations | 1 hour |
| Memory Wait Deviation | Review Performance Deviations | 1 hour |
| Network Wait Deviation | Review Performance Deviations | 1 hour |
| Table experiencing Lock Contention | Reduce Contention | 1 hour |
| Other Wait Deviation | Review Performance Deviations | 1 hour |
| Remote Provider Wait Deviation | Review Performance Deviations | 1 hour |
| Workload Deviation | Review Performance Deviations | 1 hour |
| XTP Wait Deviation | Review Performance Deviations | 1 hour |
