Yes there may be more which i am not aware of. So wanted to know views of
experts who already get to work on both of these.
I understand it's not easy to master all of these though :), but Is there
any good place/docs to see comparison of these top database technologies to
understand pros/cons and best usage etc?
On Sun, Apr 18, 2021 at 1:47 AM Lok P <loknath.73@xxxxxxxxx> wrote:
What about yugabyte?
On Sat, Apr 17, 2021 at 12:06 PM Pap <oracle.developer35@xxxxxxxxx> wrote:
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?
https://www.analytics.today/blog/oracle-vs-snowflake
Regards
Pap
