| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: 10046 event is useless in 9.2.0.4 version for response time measuring !!!
Thank you Niall for excellent comment.
I fully agree with you.
.
Thanks to Jared, Greg, Mark, Rich for sharing experience on 9.2.0.5
version.
I have 3 customers with production on 9.2.0.5 version, as well.
There are few customers on 9.2.0.4 (~1Tb OLTP). I have recommend to hold until 9.2.0.6 patchset (planed this autumn), after reading thread about 9.2.0.5 version in this list..
Niall Litchfield <niall.litchfield_at_gmail.com>
Sent by: oracle-l-bounce_at_freelists.org
03.08.2004 12:04
Please respond to oracle-l
To: oracle-l_at_freelists.org
cc:
Subject: Re: Re: 10046 event is useless in 9.2.0.4 version
for response time measuring !!!
On Mon, 02 Aug 2004 14:27:21 -0600, Daniel Fink <daniel.fink_at_sun.com>
wrote:
> If you can extract the performance problem from production and replicate
it on a non-production system, is the 6x timing issue
> really an issue? If the 6x stays constant, then you can still compare
apples to apples.
Unfortunately the factor by which times are increased is not constant. The overhead comes from the row-source execution statistics which means (in general) that operations that change between row sources frequently will suffer to a greater extent than operations that don't.
So hash joins for example will look more desirable (to the analyst - not the CBO) than NL.
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 Tue Aug 03 2004 - 04:54:51 CDT
 |
 |