Can you let us know how to measure the time taken by the session in RESPONSE state. In dbqlogtbl there is a time stamp for active
state,delay state but I am not able to find the appropriate field.
Case is :
There is one session in responding state for 9 hours and its total duration is 9:15 hours(according to Viewpoint), so when I try to fetch
information from dbc.dbqlogtbl I am not able to get total time stamp as 9:15 hours, it is giving 15mins which must be related to the time
spent in Active/Delay state and not including the time spent in Responding State, so how can I calculate the total time elapsed by the
query(end to end) including all states.
Please let us know how to resolve this, any information will be really helpful.
Thank you !!