All Forums Database
alifarhan27 1 post Joined 09/12
27 Jun 2015
Product join filter or throttling in TASM

Hi, I have applied a filter in TASM, my db version is 14.10.
1/ the filter is based on the queries whose "estimated step time" is 10min and it contains product join.
Through this filter, many of the bad product join queries are getting filtered out, but in few cases, some bad queries are being qualified by having “estimated step time” e.g. few secs only but they screw up the system for hours, is there any way we can put filter or exception based on PJI?
I want to kill those product join sessions which were passed by filter but running a bad product join for hours.
Any suggestions?

You must sign in to leave a comment.