RE: ((RE)): db_file_mutliblock_read_count and physical IO
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 19 Aug 2004 10:29:18 -0500
A man I met in Boston a few days ago said it very wisely and compactly:
"Systems don't have performance. Tasks have durations." --Mike Ryan
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 9/14 San Francisco, 10/5 Charlotte, 10/26
Toronto
- SQL Optimization 101: 8/16 Minneapolis, 9/20 Hartford, 10/18 New Orleans
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Gogala, Mladen
Sent: Thursday, August 19, 2004 10:17 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: ((RE)): db_file_mutliblock_read_count and physical IO
You should not benchmark instances, but the applications.
If you think that setting a parameter to certain value
will help you, then execute the application before and
after setting the parameter and record the difference.
You missed the whole point of the "method R". The moral
of Cary's and Lawson's book is exactly that: you do not
measure performance of an instance, because you don't have
criteria to evaluate such performance. You measure performance
of an application. The performance of applications is measured
in decibels. The louder the end users scream, the worse application
is performing. Performance of an instance is measured with BCHR.
--
Mladen Gogala
Oracle DBA
email:mladeng@xxxxxxxxx
Ext: 9787
> -----Original Message-----
> From: ryan.gaffuri@xxxxxxxxxxx [mailto:ryan.gaffuri@xxxxxxxxxxx]
> Sent: Thursday, August 19, 2004 11:07 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: ((RE)): db_file_mutliblock_read_count and physical IO
>
>
> Let's say I determined that I Had a physical IO problem. How
> would I benchmark to see if db_file_multiblock_read_count
> reduced this problem? Would I do a 10046 trace and compare
> the number of 'db file scattered reads'?
> I know I asked a similiar question yesterday, but I am
> looking for a little more. What else would you do to
> benchmark this to see if this parameter change had any affect
> on physical IO?
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
