Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle performance

Re: oracle performance

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 29 Oct 2006 11:32:22 -0800
Message-ID: <1162150344.278121@bubbleator.drizzle.com>


Charles Hooper wrote:

> My comments referring to tuning the database instance may not have been
> as clear as I had hoped.

And just to get semantically picky there is no such thing as a database instance.

There are databases ... a collection of related files. And there are instances ... processes running in memory. When one move to RAC ... the distinction is important.

One can tune the database with respect to log file size, SAME, adding LUNs, etc.

And one can tune the instance, SGA size, Sort Area, etc.

And one can tune their application getting rid of single row processing in favor of arrays, eliminating incremental commits, etc.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Oct 29 2006 - 13:32:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US