I am trying to find out the unique sqls from DBQLSQLTB.
If a particular sql is getting executed multiple times with different parameter values...that should be counted only once.
e.g. select col1,col2 from tab1 where col1='a';
select col1,col2 from tab1 where col1='b';
I want to count above 2 sql statements ONLY once, intent is to ignore all the parameter values while calculating uniqueness.
Not easy. Using DBQLSqlTbl then you'll have to do some parsing of the SQL text, essentially replacing every parameter value with a constant.
If the SQL is (or can be made to be) generated using parameter markers then that will make the process a lot easier, but the application has to do that, the DBMS cannot.