Profiles don't give you monitoring (at least AIUI). And having monitored
you'll be wanting to change SQL.
--
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
******************************************
"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3DC7F2F3.2B0D1736_at_exesolutions.com...
> 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:43:46 CST
