RE: Your opinion please :)

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 25 Feb 2004 23:29:15 +0000
Message-Id: <s03d2fdb.055@bristol21.bristol.ac>

I have to admit I don't like the paper much. it looks like a set of checklists with little or no reasoning behind them. for example the suggestions on optimizer_index_caching have just start at x and work from there. where x is apparently an arbitrary number.

my deeper problem is that the article seems to suggest that it is possible to tune systems but pays no attention to individual business processes (or indeed development modules). I disagree, the logical unit for tuning is the thing that runs badly, the logical time to do it is when writing the code for it. setting db wide parameters is sticking plaster on the titanic. perhaps.

Niall

-----Original Message-----

From: AC.GWIA.oracle-l_at_freelists.org [mailto:AC.GWIA.oracle-l_at_freelists.org] Sent: Wed 25/02/2004 18:41
To: jreyes_at_dazasoftware.com; oracle-l_at_freelists.org Cc:
Subject: Your opinion please :)

Hi I took sometime to do a paper, to help newbies in tunning, this is not to become they expert, but at least they know there are statistics in the database

If you get some time, and give some opinion about it, like the previous mistake I did with IN function, you are welcome. Or something important I'm missing (for newbies dbas of course). Did you remember the first time you had a tunning problem, before the ocp, and you didn't knew where to start to check,and lost long time, changing some database parameter to see if that improved something, the idea is to save that step.

http://www.geocities.com/juancarlosreyesp/101basictunningonOracle9i.pdf

Juan Carlos Reyes Pacheco
OCP

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

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

Received on Wed Feb 25 2004 - 17:27:12 CST