Nicing Down User Oracle Processes -- Any problems?

From: M. D. Parker <mdpc_at_netcom.com>
Date: 1997/02/04
Message-ID: <mdpcE53Esr.D1p@netcom.com>#1/1

I am a sysadmin running Oracle on an HPK4 machine with 4 CPUs. Its purpose is running oracle jobs. Some of the jobs are very CPU intensive on the user side. In order to load balance, I am thinking about nicing down user oracle processes if they exceed the usage of 30 CPU MINUTES. My DBA seems to indicate that that will cause problems with Oracle, and that oracle itself does not recommend such a procedure but I do not understand the problems here. I am a UNIX wizard but not an oracle wizard.

I was curious as to (1) if this is really true, and (2) the downsides of such a procedure, (3) does anybody else out there doing such a thing for load balancing, (4) reasoning?

Thanks...

Mike Received on Tue Feb 04 1997 - 00:00:00 CST