We are facing issue like "Too many load/unload tasks are running" due to maximum utilies limit reached. but how can we find when or at what time maximum fastload/mload, exports were running or load limit reached in system. is there any way to find through DBQL/Resusage or any other way.
some time we use rewind option(viewpoint) to check how many load utilies were running but i want to find when this situation was happen.
Appid or Queryband can be used to identify utilites in dbqlog.
Use with sessionid,starttime,firstresptime and you should be able to identify peaks.
Thanks for the response.
still i am not able to find at what time maximum loads utilities were running in system. Please help how to use above quey output.
Summarize the data for 10min interval to get number of Utility Jobs (Load/Export) started on the system at high level