Try the DBMS_RESOURCE_MANAGER_PRIVS and DBMS_RESOURCE_MANAGER packages for
implementing resource management. Details in the Oracle docs
HTH
"Steven Pannell" <steven.pannell_at_gmx.net> wrote in message
news:a4g4n0$5ld$1_at_ID-82797.news.dfncis.de...
> 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.
>
>
>
Received on Thu Feb 14 2002 - 15:48:44 CST
