Aug 22


The REORGDURATION option specifies an interval during which server-initiated table or index reorganization can start.


Schedule server-initiated reorganizations to start during periods when server activity is low. Use this option together with the REORGBEGINTIME option. The REORGBEGINTIME option specifies the earliest time that the server can start a reorganization.

You can update this server option without stopping and restarting the server by using the SETOPT command.
See SETOPT (Set a server option for dynamic update).

Read syntax diagramSkip visual syntax diagram


Specifies the number of hours during which a reorganization can start. The minimum value is 1, the maximum value is 24. The default value is 24.


Specify an interval of four hours during which a reorganization can start.
reorgduration 4


written by Bosse

Comments are closed.

i3Theme sponsored by Top 10 Web Hosting and Hosting in Colombia