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

December 11, 2007

Planning and Testing the 9iR2 to 10gR2 migration of our XXX Tb DWH

Filed under: Oracle Business Intelligence — H.Tonguç Yılmaz @ 9:52 pm

I hope following months will be my best days ever with Oracle, a lot of data waiting for a complete Oracle version and model change during our datawarehouse re-engineering project, it will be a very valuable experience for me.

I had a startup meeting today with the responsible dba team, we agreed on testing primarily;
– Automatic Storage Management(ASM),
– optimizer strategy; dbms_stats system statistics and dictionary/fixed table statistics collection,
– materialized views, bitmap indexes, table compression features and
– new backup/recovery strategy based on Flash Recovery Area solution

Please share your comments, questions and experiences on this tool or such a XXX Tb 10g Release 2 datawarehouse migration, I will be sharing mines during following months.

I am really lucky, great timing for Alejandro Vargas three days seminar on Oracle Database Maximum Availability Architecture(MAA) Best Practices next week. I will be sharing my seminar notes as usual :)

2 Comments »

  1. Note:368055
    Subject : Deployment of very large databases (10TB to PB range) with Automatic Storage Management (ASM)

    Comment by H.Tonguç Yılmaz — December 26, 2007 @ 2:50 pm | Reply

  2. […] New partition pruning features of 10g Filed under: Oracle 10g New Features, Oracle Business Intelligence, Oracle Performance — H.Tonguç Yılmaz @ 3:49 pm As I mentioned earlier I started working with our data warehouse team on their migration project; Planning and Testing the 9iR2 to 10gR2 migration of our XXX Tb DWH […]

    Pingback by New partition pruning features of 10g « H.Tonguç YILMAZ Oracle Blog — January 2, 2008 @ 3:54 pm | 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: