Watchdog is a security mechanism used by the HEAVI.AI database to prevent users from running queries that will stall or severely slow down the system.
It tries to predict the runtime and the footprint of memory and processing resources, and if the threshold is exceeded, the operation is stopped.
If you think your application's queries are valid, but the system is telling you there are insufficient resources, you can turn the watchdog off to give the system the extra time it needs.
You can turn off the watchdog completely, setting the
enable-watchdog parameter to false at the server startup.
If you don't want that your queries would run for a maximum specific time, you can enable the dynamic watchdog setting the
enable-dynamic-watchdog to true, and set the desired time limit with
You can also selectively turn off and on the watchdog or the dynamic watchdog using hints on your query.
/*+ watchdog_off */ will turn off the watchdog for that specified query. You can get more about query hints here.