Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL tuning nightmare - db file sequential reads

Re: SQL tuning nightmare - db file sequential reads

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Tue, 04 Jul 2006 16:05:48 -0700
Message-ID: <44AAF44C.6090705@comcast.net>


Mark Townsend wrote:
> Mladen Gogala wrote:

>> On Tue, 04 Jul 2006 10:38:08 -0700, DA Morgan wrote:

>
>
>> If you ever asked yourself why people are so slow to adopt
>> version 10, it is because an expensive and time consuming tests should be
>> scheduled in order to perform migration. 

>
>
> Uptake of Oracle Database 10g is actually very positive - over 40% of
> the installed base is running it now.
>
> There is another database in this
>> world which has something called "externally stored plans" and there is a
>> guy named Serge who occasionally posts on this group. He might be able to
>> provide even more info about that. That would be extremely handy when 
>> migrating to another release. Any chance of Oracle implementing that old
>> DB2 trick?

>
>
> The "old DB2 trick" is a solution to easing migration costs, but not an
> optimal one, and has it's own drawbacks. We are working on a better
> solution. Of course, you will have to upgrade (to at least 10) to take
> advantage of it.

And of course, when I use the term migration, I actually mean upgrade Received on Tue Jul 04 2006 - 18:05:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US