Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

April 24, 2007

Take the risk and migrate to 10gR2

Filed under: Oracle 10g New Features,Oracle Best Practices,Oracle Performance — H.Tonguç Yılmaz @ 7:09 am

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; https://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 :



  1. […] – 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 | Reply

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

  3. […] 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 | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: