Re: How to restrict Oracle session using too many CPU usage

From: Peter Shankey <shankeyp_at_its.charlestoncounty.org>
Date: Mon, 23 Apr 2001 17:42:32 GMT
Message-ID: <20010423.17423200@wando.charlestoncounty.org>

But the problem with this is it will cut a user off after x amount of cp u
time. I have thought about using Unix's nice command but never have.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/23/01, 5:16:36 AM, "Klaus Zeuch" <KZeuchnospam_at_hotmail.com> wrote regarding Re: How to restrict Oracle session using too many CPU usage:

> Oracle allows you to create own profiles [CREATE PROFILE] and assign

these
> profiles to users. The profile allows settings for (e.g.) cpu per sess
ion
> (CPU time limit for a session, expressed in hundredth of seconds),
> cpu per call (CPU time limit for a call (a parse, execute, or fetch),
> expressed in hundredths of seconds), sessions per users,...

> Klaus
> Anthony <nospam_at_newsranger.com> schrieb in im Newsbeitrag:
> 5XRE6.1619$QV4.129217_at_www.newsranger.com...
> > Is there any way to restrict one Oracle session to use too many CPU
usage
(e.g.
> > only allowed to use 10% of overall CPU usage)? Is Oracle having some

global
> > parameters to do such setting?
> >
> >
Received on Mon Apr 23 2001 - 12:42:32 CDT