Re: SQL tuning nightmare - db file sequential reads

On Tue, 04 Jul 2006 16:03:51 -0700, Mark Townsend wrote:
>
> 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.

Mark, thanks for your reply. You replied to me both by email and on this group. I replied by email, as I saw it first. Here is my reply, quoted almost exactly, for the general public:

On 07/04/2006 07:03:51 PM, 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.

Mark, I'm glad to hear it, but where I come from (Connecticut, USA), most of the places looking for a DBA are emphasizing "strong 9i skills". The company that I work for also runs 10gR2 - as a pilot project. Personally, I like 10g very much and I'm trying to push it, but, as I said before, there is some major and very expensive testing to be run. That is the problem.

>
> 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.

I'm glad to hear it. I built my career as an Oracle DBA, I like seeing Oracle Corp. progressing well, as this opens better chances for me to advance my own career as well. I recently had a small debate with Wolfgang Breitling about CBO problems and felt that there are some things that definitely need improvement. I agree that external plans are not without their own shortcomings. They consume a lot of space and they create a huge mess on the disk. I would prefer outlines to become a bit more versatile and movable to another tablespace or, even owned by each user, somewhat analogously to the plan table. The fact of the matter is that ever since the advent of the 9i, upgrade to the next patch release was very expensive, painful and time consuming. That pain is what I, as a user, need addressed. I am delighted by the fact that someone from the Oracle Corp. has felt the need to respond to my rant on the comp.databases.oracle.server. I am also glad that Oracle Corp. is working on making that transition less painful.
My final hope is that Oracle Corp. will turn Jonathan's book into a manual. As a DBA, I really need to know how does the CBO work. Thanks again for your swift response and kind words.

-- 
Mladen Gogala
http://www.mgogala.com





-- 
http://www.mgogala.com