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: Tom Dyess <nospam_at_nospam.spm>
Date: Thu, 22 Aug 2002 13:40:03 -0400
Message-ID: <ok999.46534$842.13130@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 - 12:40:03 CDT

Original text of this message

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