Re: oracle performance

DA Morgan wrote:
> 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.

Why don't you look through Tom Kyte's most recent book and see how many times he uses that set of words?

Where's the value add in providing a comment like yours?

>
> There are databases ... a collection of related files.

What files exactly? Any files that you choose to collect?

> And there are instances ... processes running in memory.

Well actually process allocate and use memory. They run by using cpu cycles.

> When one move to RAC ... the distinction is important.

Is that a sentence? How does "one" move to RAC?

>
> 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.

You don't seem to have read the comments in this thread. They are talking about Cary Millsap's and other peoples books on optimizing oracle performance. Received on Sun Oct 29 2006 - 14:23:30 CST