Re: Overuse of DB Resources

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 5 Nov 2002 14:18:53 -0000
Message-ID: <3dc7d34d$0$1290$ed9e5944@reading.news.pipex.net>

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


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

Received on Tue Nov 05 2002 - 08:18:53 CST