Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Overuse of DB Resources
Niall Litchfield wrote:
> "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.
> >
>
>
>
>
I stand corrected.
Or perhaps I should just sit down.
Daniel Morgan Received on Wed Nov 06 2002 - 10:12:21 CST
![]() |
![]() |