Re: see higher CPU usage after increase SGA
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 12 Jun 2004 11:49:53 +0100
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@xxxxxxxxxx>
: [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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
