Can I turn on DBQL Summary capture globally?

Database

Can I turn on DBQL Summary capture globally?

We have got DBQL running on our system, and we currently capture every query into DBQLOGTBL and DBQLSQLTBL, but not any summary data. We are looking at implementing Workloads and I wanted to capture summary data.

Can anyone tell me if there is an option to globally turn on the summary capture?
2 REPLIES

Re: Can I turn on DBQL Summary capture globally?

You put the same data in both Summary(DBQLSummaryTbl) and Details (DBQLogTbl, DBQLSQL...) tables at the same time.
Summary data is captured for a certain threshold which is defined at the time of enabling DBQLSummary. Queries qualifying within that threshold are aggregated in Summary table and the rest move on to Details tables (if Detail table logging is enabled).

Re: Can I turn on DBQL Summary capture globally?

Remember that data in DBQLSummaryTbl and DBQLogTbl is mutually exclusive, that is to say that same performance usage is not reported by both the tables at the same time. It will either fall into one or the other or none of it.