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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 1 May 2003 07:21:42 -0700
Message-ID: <2687bb95.0305010621.2becc3fe@posting.google.com>

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3EB0B7B5.4D82EFA8_at_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, you are a cruel man!

LOL -- Mark D Powell -- Received on Thu May 01 2003 - 09:21:42 CDT