Set a timeout.
Jump to navigation
Jump to search
Set a timeout.
schema:gisq
Users may accidentally (or deliberately) start queries which would take a very long time to complete. We can set a 'timeout'; this means that the system gives up after a certain amount of time.
SET STATEMENT_TIMEOUT TO 60000
ALTER SYSTEM SET RESOURCE_LIMIT=TRUE;
CREATE PROFILE gisqprofile
LIMIT CONNECT_TIME 1
;
ALTER USER scott PROFILE gisqprofile;
sp_configure 'show advanced options', 1;
reconfigure;
sp_configure 'query governor cost limit', 60;
reconfigure;
sp_configure 'show advanced options', 0
reconfigure