The secrets of Oracle scalability


One of the reasons that Oracle became a leader in database technology was their flexible tool set, a group of utilities that allows a database to grow seamlessly from a small departmental system to a giant multinational behemoth. Being the world’s most flexible and robust database, Oracle offers a wide array of tools and techniques for scaling. It is the challenge of the IT manager to apply these tools at the appropriate time to ensure seamless growth while minimizing the investment in hardware resources.

Even though hardware prices fall by a order of magnitude every decade, the investment in computing resources remains a large, critical expense that requires careful management. Hardware depreciates regardless of use, and a “too much too soon” approach can be wasteful. On the other hand, waiting until the system experiences stress related response time delays is also bad, especially since today’s end-user community has very little tolerance for sluggish response time.

The answer is the “scale up, scale out” approach.

This scalability secret allows Oracle database to grow seamlessly from tiny to behemoth. Read below for the trick:

..more..