Take a five minutes break and check the output of “select * from v$version” on your critical databases;
9.2 Oracle 9i Release 2 – May 2002
10.1 Oracle 10g Release 1 – January 2004
10.2 Oracle 10g Release 2 – July 2005
Today – April 2007 (and 11g is coming!)
Reference; http://tonguc.wordpress.com/2006/12/27/history-of-oracle/
Especially if you are a developer or dba of an OLAP Oracle database, please check these Oracle whitepapers dated July 2005;
- http://download-uk.oracle.com/oowsf2005/964wp.pdf (paper)
- http://download-uk.oracle.com/oowsf2005/964.pdf (presentation)
- http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_general_sort_performance_10gr2_0605.pdf (paper just for sort)
The improvements in algoritms for both in-memory sort and hash based aggregation are special cases with 10gR2, any 10gR2 migration is of course something to be tested carefully but this time we have more promising arguments and motivation in doing so.
After all sorting and aggregation are what a data warehouse system lives for :)
Remember two more important motivations;
1- in any case if you need Oracle’s support they will somehow first request you to install the latest patch,
2- Also there are lots of great new features you may enjoy with Release 2 like “Flashback Database Restore Points” and “Error-Logging Clause”
Refences Used :
http://www.oracle.com/technology/pub/articles/10gdba/index_r2.html
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14214/toc.htm
[...] – you will be telling these sentences to your top management and they will immediately ask why R1? immediately plan and test to migrate to Release 2 as I mentioned earlier. – always get prepared for the worst and have a b-c-d.. plans :) – if you want high performance [...]
Pingback by I am back :) « H.Tonguç YILMAZ Oracle Blog — July 13, 2007 @ 7:35 am |
from the cost perspective this is another important motivation – http://laurentschneider.com/wordpress/2007/08/9ir2-desupport.html
Comment by H.Tonguç Yılmaz — October 16, 2007 @ 4:47 am |
[...] to be re-structured from bottom to top. So this was a great opportunity for me to advice both continuing with 10g Release 2 and using Oracle’s OLAP features like star transformation and materialized views which the [...]
Pingback by Oracle OLAP features performance testing Part 1 « H.Tonguç YILMAZ Oracle Blog — January 21, 2008 @ 10:29 am |
[...] – http://tonguc.wordpress.com/2007/07/16/deffensive-upgrade-methods-but-still-no-pain-no-gain/ – http://tonguc.wordpress.com/2007/04/24/take-the-risk-and-migrate-10gr2/ – [...]
Pingback by Again on data migration best practices for Oracle database « H.Tonguç Yılmaz - Oracle Blog — May 4, 2008 @ 8:09 am |