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 |
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center