Querybanding and Changing Workload

Database
Enthusiast

Querybanding and Changing Workload

I have a scheduled job(a set of CPU intensive statements) which should run under a high priority workload during off business hours and should run under a low prioirity workload when the sytem is busy during business hours.

Can I use query banding to change the workload of  job ?Where do i need to make the changes for the system to recognise and promote or demote the session to the corresponding workload depending on the time of day?We are using Viewpoint.Do you need to configure the information in viewpoint portlet?

1 REPLY
Junior Contributor

Re: Querybanding and Changing Workload

Of course you can assign a workload based on QueryBand or whatever you want, you just have to check where/if it fits into your current WL definitions/state matrix.

This has to be done using the Workload Designer portlet.