Real-World Performance Videos on YouTube – Data Warehousing

Here are some videos of a data warehouse demo that the Real-World Performance Group has been running for a while now and we thought it was time to put them on YouTube. Hope you find them informative.

Migrate a 1TB Data warehouse in 20 Minutes (Part 1)

Migrate a 1TB Data warehouse in 20 Minutes (Part 2)

Migrate a 1TB Data warehouse in 20 Minutes (Part 3)

Migrate a 1TB Data warehouse in 20 Minutes (Part 4)

7 comments

  1. Pingback: Real-World Performance Videos « Datatombraider's Blog
  2. mdinh

    Is the load using external tables? Is the parallel on the same table? Or are there multiple processes loading different tables in parallel?

    Thanks.

  3. Greg Rahn

    The data is loaded with parallel direct path loads (APPEND + PDML) from external tables using the preprocessor as the source flat files are compressed.

  4. Paresh

    Keep the great presentations coming. Everything was worth watching but my top 3 take away are:
    1) Doing Set based validation
    2) Incremental stats
    3) Using query queuing to improve performance which initially seemed counter intuitive.

    A quick question:
    Does schedule manage queuing by itself or we have to prime it with information about what to queue and how much to queue based on actual queries that will be run (probably not as what do we do than with adhoc queries)?

  5. Pingback: Real World Performance seminar « Derya Oktay's Oracle Weblog

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