Re: see higher CPU usage after increase SGA

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 12 Jun 2004 11:49:53 +0100
Message-ID: <098301c4506a$fe2a7f90$7102a8c0@Primary>

Notes in-line

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st

Original Message ----- From: "Cary Millsap" <cary.millsap_at_hotsos.com>
: [Cary Millsap] Jared's right. Ratios will never work for you in this
: pursuit.
:

Cary, I may have lost track of which person originated which comment - but if this is yours, then I think you need to qualify it carefully. Many on this list will understand the point you are trying to make, but as it stands, it falls into the same category as statements like: "tablescans are bad". It is very easy to produce an example where a reduction in LIOs has a negative impact on scalability. (Think of the case where a sensible indexed access path is turned into a stupid tablescan).

: 1. Fewer LIOs means better scalability.
:
: 2. Fewer latch acquisitions means better scalability. (How to acquire
fewer
: latches? See #1.)
:
: 3. Fewer dbcalls means better scalability. (For example, process arrays
: instead of one row at a time.)
:

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

Received on Sat Jun 12 2004 - 05:46:57 CDT