create rules for a user and specify LIMIT SUMMARY=5,10,15 and during the next session, and every query takes longer than 5 seconds but less than 10 seconds to complete |
all queries fall into the second bucket (5 to 10 seconds), so the second group is the only query count logged for the session in DBQLSummaryTbl. |
create rules for a user and specify LIMIT SUMMARY = 5,10,15 and during the next session, every query completes in less than 5 seconds |
all queries fall into the first bucket (up to 5 seconds), so the first group is the only query count logged for the session in DBQLSummaryTbl. |
create rules and specify LIMIT SUMMARY=1,15,10 |
the statement is accepted (no checking is performed on SUMMARY input values) but the results are unpredictable. |
create rules for UserA and specify SQL, OBJECTS LIMIT THRESHOLD (without a time value), and UserA then processes four queries, where:- One query takes more than 5 seconds to complete
- Three queries complete in less than 5 seconds
|
the statement is accepted and the default value of 5 seconds is assigned. For the next session of UserA:- The longer query is logged in DBQLSqlTbl, DBQLObjTbl, and DBQLogTbl, with values in all valid fields of the rows.
- For each of the three shorter queries:
|
create a rule and specify LIMIT THRESHOLD=100000 |
An error is returned; THRESHOLD must be less than 32K. |