Re: SQL Tuning Regarding System CPU Stats

On Thu, 17 May 2007 08:55:33 -0700, andrew.markiewicz wrote:

Hello all.
We are in the process of upgrading from 9i to 10g and starting to use
system statistics. Since the system statistics are used per database
instance and not per user/schema, what approach is recommended for
tuning a production system within a development environment?

The best approach is: if it ain't broken, don't fix it. Besides that,
what does it mean to "tune production system"? I was under the impression
that applications are what needs tuning, not the system. There is a little
known book, published by O'Reilly few years ago, named "Optimizing Oracle
for Performance", written by two guys, Cary Millsap and Jeff Holt. The
book is as timeless as Mona Lisa, but not as inscrutable. It certainly
doesn't depend on Oracle version. It deals with performance problems from
the philosophical point of view and answers the question of life universe
and everything. There is also a prolific author named Tom Kyte who writes
various things, Oracle books among other things. I can wholeheartedly
recommend his collected works, too. Further reading would include Cost-
Based fundamentals by Jonathan Lewis, RAC Handbook by K. Gopalakrishnan,
Oracle 10 Wait events by Kirti Deshpande (phenomenal book!!!) and Dan
Tow's SQL Tuning.
For further specialized topics, I would recommend numerous available
articles by Tom Kyte, Jonathan Lewis, Wolfgang Breitling, Tim Gorman,
The Hotsos gang, Julian Dyke, Howard Rogers, Connor McDonald as well
as specialized DW books by Ralph Kimball and Gavin Powell.

--
http://www.mladen-gogala.com
.

Relevant Pages

  • Re: Parameter to influence Oracles Idea of IO Cost?
    ... Does my memory fail me? ... This parameter does not affect the cost of a single table ... Oracle docs are a bit sparse IMHO. ... SYSTEM STATISTICS INFORMATION ...
    (comp.databases.oracle.server)
  • Re: SQL Tuning Regarding System CPU Stats
    ... Since the system statistics are used per database ... tuning a production system within a development environment? ... known book, published by O'Reilly few years ago, named "Optimizing Oracle ... CPU stats that will then be used to generate SQL statements, ...
    (comp.databases.oracle.server)
  • Re: Copy of schema only
    ... > I have just started a new job which was supposed to involve tuning some SQL ... > Oracle DBA and never claimed to be; I find it difficult to understand how ... > The prod DB is Oracle 9i running on HP-UX and the dev DB ... uname -a is very informative on both unix. ...
    (comp.databases.oracle.server)
  • Re: Using Cursors
    ... > different than SQLServer in that they highly recommend not to use the ... > temp table solution when I code Oracle. ...
    (microsoft.public.sqlserver.programming)
  • Re: Gathering accurate system stats prior to 10g upgrade
    ... This is another question about system statistics. ... In our environment Oracle accesses our SAN based ... multiblock read time is significantly less at around 2.5ms, ...
    (comp.databases.oracle.server)