Archives of the TeradataForum
Message Posted: Wed, 19 Jul 2000 @ 19:25:57 GMT
I am not an Oracle or Teradata DBA, however, I worked in an environment where we utilized Oracle as our Production DB and Teradata as our Warehouse DB. I was jointly responsible for the maintenance of our system which involved in minor Oracle and Teradata Maintenance and the over-all performance of the system. Without knowing specific questions regarding maintenance, I will say that Oracle seems to require more overhead than Teradata and is certainly less forgiving than Oracle. Oracle also seems to require more re-orgs than normal. Now this could be related to the Database structure, but we purchased a Sun 6500 and moved our Oracle DB to the new machine which would be a Reorg. Performance improved dramatically as expected, however, in less than a year later, Database retrieval was beginning to slow down to a noticeable level yet our environment would not dictate such a performance drop-off in the short amount of time. The conclusion (last of I knew of) was Reorg. Reorgs in Oracle are very time consuming.
One more thing: If you run the same query against the same table with the same layout in Teradata and Oracle, the results would be very different: Teradata would take about 1/10 of the time than Oracle does to retrieve the data.
This probably doesn't help and you probably already know the above, but I figured I would share it with you any way.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|