SQL Developer Alert Notification Suppression and Scope
0 reputation · 14 Feb 2020, 20:14 UTC
Row Count Alert Configuration
Oracle SQL Developer allows the creation of alerts that trigger when a table's row count exceeds a specific threshold. These notifications can be delivered via pop-ups, logs, or email to monitor data growth or unexpected insertions.
Notification Noise and Scope Constraints
Current behavior indicates that alerts fire for every instance a threshold is violated during a polling cycle or change event. In environments with high-frequency data updates, this creates significant notification noise because there is no built-in suppression window or cooldown period to limit the frequency of pop-ups.
Additionally, these alerts appear to be global to the connection rather than scoped to specific users or schemas, potentially disrupting all active sessions regardless of their role in the data update.
- Is there a configuration to implement a suppression window for repeated alert triggers?
- Can alert notifications be restricted to specific database users or schemas to reduce noise for unrelated sessions?