Re: Limit database useage for a user

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Thu, 14 Feb 2002 16:08:30 +0400
Message-ID: <05an6usskdjhaa5njk597sivjsprir2iv4@4ax.com>

RTM On Profiles and Resource Limits.

Also the Resource Capacity Planner may be useful in this regard.

HTH On Thu, 14 Feb 2002 11:49:35 +0100, "Steven Pannell" <steven.pannell_at_gmx.net> wrote:

>Hi,
>
>I would like to limit an oracle database user to use say 10% of the overall
>processing power of the oracle database. I would like this funcationally to
>stop large and long statements killing the database i.e. no one else can
>work while the statement is running. Is this at all possible?. To limit
>the processing usage for a specific users?
>
>Thanks for any help,
>Regards,
>Steve.
>
>

[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Thu Feb 14 2002 - 06:08:30 CST