Database comparison
From: Pap <oracle.developer35_at_gmail.com>
Date: Sat, 17 Apr 2021 12:06:16 +0530
Message-ID: <CAEjw_fhXUtxzYUOpNUJd2+9+4zXBLWwGTi2PzxARZAwaVGuV9g_at_mail.gmail.com>
I understand there are multiple arguable topics on what is best what not. We are currently using Oracle Exadata X7 and planning for migration to X8. But yes we do see at times , cell I/O saturation (mainly when heavy cell smart scans from multiple places) and other types of memory related contentions and it's mostly because of the way Oracle architectured making memory a lot busier or a hotspot while we just simply push the concurrent workload beyond a certain limit.
Pap
Date: Sat, 17 Apr 2021 12:06:16 +0530
Message-ID: <CAEjw_fhXUtxzYUOpNUJd2+9+4zXBLWwGTi2PzxARZAwaVGuV9g_at_mail.gmail.com>
I understand there are multiple arguable topics on what is best what not. We are currently using Oracle Exadata X7 and planning for migration to X8. But yes we do see at times , cell I/O saturation (mainly when heavy cell smart scans from multiple places) and other types of memory related contentions and it's mostly because of the way Oracle architectured making memory a lot busier or a hotspot while we just simply push the concurrent workload beyond a certain limit.
While googling around the data warehouse/analytics databases i came across a blog as below saying how snowflake is superior to Oracle( or maybe Exadata). Some of the points it says like no indexes, no partitioning, no statistics gathering, linearly scaling, auto compressing seems interesting.
I understand this list group is mainly expert around oracle databases, but assuming that some must have explored other databases options or get a chance to work on other databases, are these points all true and Snowflake is currently the best warehouse/analytics database in the market now or any other databases are there proven record?
Regards
Pap
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Apr 17 2021 - 08:36:16 CEST