Toad World® Forums

Trace File Browser Filter Exclusion Capabilities

Is there an easy way to exclude dynamic sampling from the TFB? I think this is just the SELECTs with an embedded /* DS_SVC */ or the hint dynamic_sampling(0). An separate exclusion filter box like the “Filter by query text:” or some NOT syntax would even be a bit more flexible.

There’s no way to do that now, but I can add the ability to make the “filter by query text” support “not”. I’ll add this for next beta.

OK, next beta, if the first character of the filter is an exclamation point, then we’ll treat that as “not”.

For example, to show all sql that lacks the word “select”, filter by: !select