Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 20 Jul 2000 @ 06:15:14 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Oracle vs Teradata DBA maintenance
From:   John HR Schuster

I agree with JK Wight. I have been recently a DBA on Oracle (Financials warehouse) and in the past Teradata (Medical warehouse) and I spent much more time setting up and managing just the tablespaces in Oracle than I did in all administrative tasks total for Teradata.

We did Oracle reorgs at least every 10 months and it took a few weeks to plan each one out. I never did a reorg on the Teradata system. I also spend about 20% of my time planning out complex queries under Oracle where I may have spend 2% of time doing the same under Teradata. Big problem I had was the tool of choice (Business Objects), if you set up the universe even slightly wrong under Oracle the queries are going to take much longer than necessary. I seemed to have a bit more leeway with Teradata. I ended up creating single views for single reports, more administration. A couple of "Creative users" can bring a large UNIX system with Oracle down to it's knee's, the Teradata was more robust.

The UNIX to UNIX transfer of the financial system took most of the batch window during the evening and total space was 100-150GB. We could load 500GB or more with the Teradata connection. Many times we never finished the Oracle load and the warehouse was 2 days behind.

I joke with folks now as a consultant that I like Teradata... but I loves Oracle.... I get paid by the hour ;-)

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023