The following SELECT statement retrieves the summary information of a session (if logging is initiated with “Replace Query Logging limit Summary = 10,15,20 IOCOUNT on all;”):
replace query logging limit summary = 10,15,20 IOCOUNT on all;
To see the rules:
select * from dbqlrulesv;
Result:
UserName All Account ApplicationName TypeOfRule Logging enabled Explain F Object F SQL F Step F XMLPlan F StatsUsage F Verbose F DetailedStats F NoColumns F Summary T Threshold F ObjectUsage F Param F FeatureUsage F UtilityInfo F TextSize 200 Summary//Low 10 Med 15 High 20 LockDelay 0 AlgMode ? TypeOfCriterion IOCount DetailDiag ?
The following SELECT statement retrieves the summary information of a session:
select * from QrylogSummaryV sample 1;
Result:
ProcID 30718 CollectTimeStamp 2016-11-04 12:45:35.460000 UserID 00000100 AcctString DBC LogicalHostID 1 AppID DBCCONS ClientID PTEUSER ClientAddr 10.25.176.76 ProfileID ? SessionID 1,386 QueryCount 1 ValueType I QuerySeconds 0.000 AverageTime .000 TotalIOCount 0 AverageIO AMPCPUTime .000 AverageAmpCPU .000 ParserCPUTime .004 AverageParserCPU .004 AMPCPUTimeNorm .000 AverageAmpCPUNorm .000 ParserCPUTimeNorm .253 AverageParserCPUNorm .253 LowHist 0.000 HighHist 10.000 UsedIota 0.000 ReqPhysIO 0.000 ReqPhysIOKB 0.000 StartTime 2016-11-04 12:38:20.390000 StopTime 2016-11-04 12:38:20.390000 UserName DBC