Re: Info About use of Oracle for terrabyte databases.
Date: Thu, 12 Aug 1993 16:24:32 -0500
Message-Id: <199308122124.AA19370_at_risc.agsm.ucla.edu>
In article <24dvgr$bis_at_news.utdallas.edu> you write:
>I am looking for information about the use of Oracle DBMS for
>managing terrabyte databases. More specifically, I am looking
>for existing or planned very large databases using Oracle in
>financial,business,credit,online applications. I am interested
>in the performance of oracle as a VLDBMS. I am looking for any info
>on sites currently using or planning to switch to Oracle in the near
>future for terra-byte database management.
>
>I would appreciate either direct replies or replies on this group.
>I will post a summary of responses.
>
>-SK
Given my experiences, a Terabyte is about an Order of magnitude too large to be successfully managed on an RDBMS given today's available unix hardware. 100 gig, painful but it can be made to work. There are I/O bus limitations that I have not seen solutions to yet that prevent most unix machines from thrashing when doing, say, a 100 gigabyte table scan. This takes HOURS and HOURS on any machine I've benchmarked on.
Perhaps with Oracle 7.1, or on the new massively parallel machines this will become feasible. I assume you don't want to run Oracle on a cluster of 3090's..
There is a VLDB group at Oracle you can contact to speak with their largest users.
Good Luck.
- Dan
Daniel Druker
Anderson Graduate School of Management at UCLA
| Dan Druker | | agsm mail : ddruker | | internet : ddruker_at_agsm.ucla.edu | | oracle*mail : unix:ddruker_at_agsm.ucla.edu | ----------------------------------------------------------------------------
Disclaimer: None. I'm a student now and I don't care what you think. Received on Thu Aug 12 1993 - 16:30:23 CEST