Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle performance
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.orgReceived on Sun Oct 29 2006 - 13:32:22 CST