Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting CPU usage for a user

Re: Limiting CPU usage for a user

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 23 Aug 2002 17:07:15 GMT
Message-ID: <3D666BB3.8EABC0F@exesolutions.com>


Richard Foote wrote:

> 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
> > > >
> > > >
> > > >

From your experience does this apply to consumer groups and other means of controlling resource utilization?

Daniel Morgan Received on Fri Aug 23 2002 - 12:07:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US