Re: Can you change a priority of the query?

Resource manager plans in Oracle8i 8.1.5 allow you to do exactly this (for groups of users). Prior to this you could use profiles to kill the query once it consumes a certain amount of resources

comtrex_inc_at_my-deja.com wrote:
>
> Hi,
> I would like to know if it is possible to manage priority of a running
> query.
> I would like to be able to control the impact of the jobs on the
> responsivnes of the system.
> thanks a lot
> robert
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
Regards,

Mark Townsend                         

Senior Product Manager				Ph: 	(650) 633 5764
Server Division					Fx: 	(650) 506 7222
Oracle Corporation				Email:	mtownsen_at_us.oracle.com