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 dynamic-watchdog-time-limit
.
You can also selectively turn off and on the watchdog or the dynamic watchdog using hints on your query.
adding /*+ watchdog_off */
will turn off the watchdog for that specified query. You can get more about query hints here.
Comments
0 comments
Article is closed for comments.