Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting CPU usage for a user
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 Thu Aug 22 2002 - 23:40:46 CDT