This discussion is now locked
Posted by Michael Tiefenbacher on 28 May 2008 at 1:00
there is someting strange in the description of Thresholds. The book states that the threshold domain includes Work Actions. (page 16)
But on page 17 the domain is referenced as Work Action Set.
In the CREATE WORKLOAD command there is NO way to specify either a work action nor a work action set.
Can someone (of the authors) clarify that?
Thanks in advance
Posted by Bill Comeau on 29 May 2008 at 10:06
Hi Michael ...
Because work actions (sets) can be applied at different levels the thresholds are actually incorporated into the CREATE WORK ACTION SET command. Here is an example:
CREATE WORK ACTION SET myactions FOR DATABASE
USING WORK CLASS SET myclasses
(WORK ACTION stop_large_read_wa ON WORK CLASS read_wc WHEN ESTIMATEDSQLCOST > 1000000 STOP EXECUTION)
Page 18 talks more about this and there are more examples later in the book.