Technical Capabilities

From: Peter Tan <petertan78_at_yahoo.com>
Date: Tue, 6 Nov 2001 22:44:17 +0800
Message-ID: <3be7f4d5$1_at_news.starhub.net.sg>


What is the technical capabilities of 9i ? I couldn't seem to find any specifications for it. From what I saw from Sybase, I could see that its maximum size of BLOB is at 8 GB and maximum table is 4 GB. What abt Oracle ?

My wife, who is a DBA herself, seems to find that Oracle 9i is slower than most other DBs. I assume that the complexity of Oracle would be a bottleneck in performance. But other than adding new systems, are there performance tuning details I should look at in making Oracle 9i faster ?

Finally, our company is planning to launch an initative - to cover 300,000 users within 4 phrases, with each phrase lasting half a year. Each of the users will be given at least 40 - 50 mb of space, thus I would need around 15,000,000 mb or 15 TB of space.

At each phrase, we would need to have procure new servers to accommodate these users. And the best way that I can think of is clustering. I am looking at a rack of clusters of HP LP1000r to store the information. But looking at it from my perspective, I found that each unit has only 109.2 GB of space. How am I going to consolidate all of these storage spaces as a "whole" and yet to maintaind data integrity and security ?

What can Oracle do for me, in this problem ?

--
Received on Tue Nov 06 2001 - 15:44:17 CET

Original text of this message