Perfect Query Timings needs to be captured

Database
Enthusiast

Perfect Query Timings needs to be captured

Perfect Query Timings needs to be captured.

Hello, we are using Teradata13.10 Version and using Viewpoint also. We are using OBIEE 11g tool to refreshing the reports.

Daily basics we runs 10000+ reports against to Teradata by using PROD_OBIEE_USER user (Only one User-DBQL log is enabled)

As per client requirement, how to analysis how many queries were completed within 10mins?

                                                                                                                          Between 10mins to 20min?

                                                                                                                          Between 20min to 30 mins?

I was trying to take metrics from DBQL, It was not showed correct results?

Please help me out from this situation, Please provide me valid query for checking above timings?

Tags (1)
1 REPLY
Enthusiast

Re: Perfect Query Timings needs to be captured

The starttime column in the dbc.dbqlogtbl table is when the query started. FirstRespTime is when the query was completed and the first row of the resultset was returned to the user/application.

Your query, depending upon what other fields you need from dbqlogtbl will look something like this...

SELECT (FIRSTSTEPTIME -  Starttime) MINUTE TO SECOND AS ELAPSED FROM dbc.dbqlogtbl