RE: Oracle 911 Article

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Fri, 5 Mar 2004 12:24:29 -0800 (PST)
Message-ID: <20040305202429.5079.qmail@web20412.mail.yahoo.com>

Jared Still <jkstill_at_cybcon.com> wrote:
> We have a similar change management process.
>
> I am 'privileged' to be the owner of that process.
> :)
>
> Finally got to bounce the box yesterday where I had
> set session_cached_cursor=1500 over a month ago.
>
> And yes, it was tested first, and the results
> shared.
>
> Unless there is an absolute emergency due to a
> downed
> system or severely impacted performance, changes go
> through a review meeting first.
>
> Emergency changes are still discussed and recorded.
>
> For many of you, wait will Sarbanes Oxley is gets
> hold
> of you. You will either be implementing change
> control,
> or vastly 'improving' your current process.
>
> Jared

session_cached_cursor=1500

Really?
I'd love to see the data (or graph) of parse reduction (and associated resource reduction) vs.
session_cached_cursors.

I just hiked it to 100 and left it there.

Hmmm. Guess I'm interested in "The Burden of Proof" if you care to share.

thanks.

>
>
> On Fri, 2004-03-05 at 01:51, Niall Litchfield wrote:
> > > You guys are going to enjoy this :-).
> > >
> > > I just read a very interesting article that
> managed to insult
> > > some of my
> > > favorite Oracle authors and the entire state of
> Alabama!
> >
> > Hmm we have a script with a number of ctas
> statements in it
> >
> > Where 'pope'='catholic'
> > Where 'manager name'='in'
> > Where 'niall'='big and clever' etc
> >
> > I read the alabama comment in the same light.
> >
> > > Now
> > > I've heard Mr.
> > > Burleson speak before, and I must admit that I
> thought he was
> > > a dynamic and
> > > entertaining speaker. But do you really think
> that Oracle
> > > Support has ever
> > > told anyone to call HIM to solve their
> performance problems
> > > (his article
> > > makes this claim)?
> >
> > I doubt that oracle support make specific partner
> recommendation in an iTAR though they might. On the
> other hand if you have purchased support from oracle
> because you have no-one experienced in house (though
> why you would then be running oracle is beyond me) I
> can imagine support saying something along the lines
> of , "well if you are uncomfortable with doing this
> you might hire either ourselves or a third party
> oracle specialist to do this work for you". The
> first consultancy site that is returned in a google
> search for "oracle expert" is www.dba-oracle.com
> >
> > In general I didn't like the tone of the article,
> but I do have to agree with jonathan that the
> article focusses on business problems and
> implications for clients, I like that. That said I
> find this approach hard to square with "Unlike
> academic and scientific Oracle DBAs who demand
> proofs and reproducible results before making an
> Oracle change". We can't be the only Oracle house
> that has a change management process that involves
> reproducing problems on test and applying a fix to
> show that it works first can we? This is a business
> process and definitely not a result of the DBA
> insisting on proof before changes are applied. All
> good change management requires some evidence that
> the change will have the desired effect - doesn't
> it?
> >
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission
> > +44 117 975 7805
> >
> >
> >
> >
> >
> >
> >

>

> > This email contains information intended for
> > the addressee only. It may be confidential
> > and may be the subject of legal and/or
> > professional privilege. Any dissemination,
> > distribution, copyright or use of this
> > communication without prior permission of
> > the sender is strictly prohibited.
> >

>

> >
> >

>

> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >

>

> > To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> http://www.freelists.org/archives/oracle-l/
> > FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
> >

>

>

>

> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com

>

> To unsubscribe send email to:
> oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> http://www.freelists.org/archives/oracle-l/
> FAQ is at
> http://www.freelists.org/help/fom-serve/cache/1.html
>

Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sat Mar 06 2004 - 00:30:08 CST