Re: [Q] V7.0 vs. V7.1?

> What is involved in a port from the Oracle V7.0 RDBMS to the Oracle
> V7.1 RDBMS? As I understand it, the only difference is the the
> parallel server option and all of the internals, structures, et al.
> remain the same.
 

> I would appreciate any information that anyone would care to provide
> on this subject. Good or bad accepted without prejudice.

Some of the things that have to be considered include:

1. Setting the degree of parallelization of tables. This is best done by experimenting with your common queries and determining the level of parallelization that gives you the best response.
2. The Oracle cost-based optimizer is much more practical in 7.1. This means that you may have to devise a statistics-gathering plan.
3. If you optimized queries by setting the order of tables in the from clause (which the books said would not work), you will have to give the ordered hint to achieve this same goal.
4. We found that 7.1 consumed a much greater number of cursors than 7.0 for the exact same application.
5. SQL*Loader provides a direct load and parallel load option that may speed the process. We found that the basic SQL*Loader worked slower under version 7.1 than it did under 7.0 (for the same load set) even though our insert times improved.
6. We found a fair number of bugs in our Sequent release of 7.1.3 (Oracle even called them bugs instead of features). Most of the bugs are supposed to be fixed in 7.1.4 which is out for many platforms. I would recommend trying 7.1.4 if it is available.

Good luck. Received on Fri Dec 23 1994 - 03:43:32 CET