Re: How to tune for "too many" users ?

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 30 Apr 2003 22:59:17 -0700
Message-ID: <3EB0B7B5.4D82EFA8@exxesolutions.com>

"Ana C. Dent" wrote:

> Jan Gelbrich wrote:
> > Hello, NG
> >
> > what would be the right strategy to tune the instance, so that "too many"
> > users do not slow down
> > the whole thing.
> >
>
> Unplug all the user's keyboards so they can't put a load on the DB.
> Presto, chango! The load problem has been solved.

Some user's might plug them back in. I prefer:

ALTER PROFILE default LIMIT

CONNECT_TIME 1
CPU_PER_SESSION 1
LOGICAL_READS_PER_CALL 1

FAILED_LOGIN_ATTEMPTS 1
PASSWORD_LOCK_TIME 1000; And best of all ... 90%+ of DBAs couldn't find it.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Thu May 01 2003 - 00:59:17 CDT