Re: Overuse of DB Resources

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3DC7F71A.EF625D4E_at_exesolutions.com...
> Daniel Morgan wrote:
>
> > Alek Voronov wrote:
> >
> > > 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.
> >
> > Go to http://tahiti.oracle.com and put in the search criterion
"Profile".
> >
> > You should set up profiles based upon classes of users and limit not
just
> > CPU utilization but other resources, logons, password expiration,
password
> > reuse, etc.
> >
> > Daniel Morgan
>
> I agree. But he didn't ask for monitoring. Just the ability to "protect
> against overuse."
>
> If you limit CPU utilization to safe levels ... there is no need to
monitor
> anything other than the ensuing complaints from those that write Cartesian
> joins.
>

Daniel ,
I assume you are replying to me not you:( The supplementary Alex asked was

" any tools available in Oracle to monitor system resources?"

which prompted my starter list.

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