Skip to Main Content

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Geetika .

Asked: July 18, 2016 - 7:16 am UTC

Last updated: July 18, 2016 - 9:12 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Why it is difficult to scale oracle database.

Thanks!!

and Chris said...

When you get to extreme scale (Google, Facebook, etc.) scaling any database is hard!

But most of us are not going to get anywhere near that level of scale. For the levels most of us need to get to Oracle Database scales easily. Even NoSQLers admit this:

Despite what you may read in NoSQL vendor marketing materials (or even in my blog), it is possible to scale Oracle.

http://www.infoworld.com/article/2613467/application-development/how-do-i-freaking-scale-oracle-.html

To ensure you have good scalability, the first thing to check is that your data model supports your needs. Assuming this is the case, Oracle Database has a number of options to help you scale:

http://www.oracle.com/technetwork/database/performance/db-perfscale-11gr1-twp-129806.pdf

Also check out the performance and scalability development guide:

https://docs.oracle.com/database/121/ADFNS/adfns_perf_scale.htm#ADFNS131


Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.