sessions delayed due to throttles

Database
Enthusiast

sessions delayed due to throttles

hi,

The number of delayed sessions in our TD system increases time to time in business hours. We want to relate them with throttles (if it is high due to throttles defined in the system). So kindly let us know the system table/view name which can tell us the sessions getting affected by respective Throttle Rule Set.

Regards,

Deepak D

2 REPLIES
Enthusiast

Re: sessions delayed due to throttles

Deepak,

The delayed sessions can be identified by verifying the dbc.qrylogtdwm table where delaytime is not null. In some cases the delaytime can be 0.

Based on the delaytime in the above, capture the WDID and see if that is caused by throttling or otherwise.

Krishna

Enthusiast

Re: sessions delayed due to throttles

Thanks Krishna for the Update...