|
|
Archives of the TeradataForum
Message Posted: Wed, 19 Jul 2000 @ 19:25:57 GMT
Subj: | | Re: Oracle vs Teradata DBA maintenance |
|
From: | | Timothy Gist |
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.
Tim Gist
| |