Re: Overuse of DB Resources

Niall Litchfield wrote:

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

All that when a simple alteration to the default profile would suffice? ;-)

Daniel Morgan Received on Tue Nov 05 2002 - 10:34:07 CST