Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Overuse of DB Resources
There are literally tons of tools out there that may help you. Some tools of
note
STATSPACK - free with Oracle.
Resource Manager - also free with Oracle.
Spotlight - from Quest Software.
Patrol - from BMC Software.
Of the above Resource Manager seems to do what you are asking, but I'd suggest that you may in fact wish to be tuning the efficiency of the SQL that is run against your databases rather than limiting the resources of specific sessions/users etc.
Others no doubt will have other recommendations.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Alek Voronov" <voronov_at_milcse.cig.mot.com> wrote in message news:8300330.0211050557.4f958c78_at_posting.google.com...Received on Tue Nov 05 2002 - 08:18:53 CST
> any help on how SQL interface (SQL access from user or 3rd party
> applications) can be protected against an overuse of the Oracle DB
> Resources will be very appreciated!
>
> that is, we have Oracle DB and various users (or 3rd party apps) which
> can access the DB via SQL. We have to limit these accesses to prevent
> 100% CPU utilization, full memory using etc (what else?). any tools
> available in Oracle to monitor system resources?
>
>
> Thanks, Alek.