FreeLists / oracle-l / Re: Re: 10046 event is useless in 9.2.0.4 version for response time measuring !!!

[J.Velikanovs@xxxxxxxx]

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.
.
But after 10046 bug discovery, it is seems that 9.2.0.5 can be the option 
in this accounts as well.
.
Thanks to all again,
Best regards,
Jurijs





Niall Litchfield <niall.litchfield@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
03.08.2004 12:04
Please respond to oracle-l
 
        To:     oracle-l@xxxxxxxxxxxxx
        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@xxxxxxx> 
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------