Re: Limiting CPU usage for a user

Sorry, no info for Oracle on NT - other than setting up a test box.

Under HP-UX you could use PRM (Process Resource Manager) to assign pset's (CPU's dedicated to specific processes), or to allocate CPU shares (guaranteed minimum percentages of CPU, or memory or IO). Or, for example, to place CPU caps on a certain group of development processes.

Or even vPars, where you could have multiple kernels booted and running on one box at the same time - each with it's own dedicated portions of the system hardware.

Eric Stahl

"Tom Dyess" wrote:

>We have two instances on a single box, one for DEV and one for PROD. We have
>a reporting person who is attempting to optimize her SQL statments but
>unfortunately is bringing down both instances. Is it possible to limit the
>amount of CPU a session can consistantly use? The CPU_PER_SESSION in
>profiles isn't adequate because she needs to completely run the queries, but
>I want to still allow other users have a dedicated percentage of clock
>time - this particular box runs Windows 2000.
>
>Thanks,
>Tom
Received on Fri Aug 23 2002 - 02:02:49 CDT