Re: Limiting CPU usage for a user

Hi There,

Just note that resource manager doesn't kick in with the CPU resource until the CPU is seriously maxing out. Until then, all users get equal share of CPU. Cheers

Richard
"Steve" <smontgomerie_at_hotmail.com> wrote in message news:156709aa.0208222040.51a9fe25_at_posting.google.com...
> have a look at Oracle8i Concepts chapter 9 on
> Database Resource Management.
>
> You might consider after reading that creating resource consumer
> groups/plans
> and limiting cpu usage, parallelism etc from that.
>
> In 9i there is a enhancement (switch group or time..i forget) that
> will
> detect long running processes and switch them to group which has
> different priorites on resources
>
> steve
>
>
> "Tom Dyess" <nospam_at_nospam.spm> wrote in message
news:<ok999.46534$842.13130_at_news1.fdn.com>...
> > Oops, also Oracle 8.1.7
> >
> > "Tom Dyess" <nospam_at_nospam.spm> wrote in message
> > news:cj999.46533$842.12954_at_news1.fdn.com...
> > > 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 - 01:15:53 CDT