This is close to 100 transcations /sec continuesly. What kind of hardware do
you want to use for that? You would have 640 MB data every day. That's A
LOT.


----- Original Message -----
From: "Paul Kavanagh" <Paul.[Email Address Removed] Friday, August 31, 2001 12:05 PM
Subject: Big Oracle Databases


>I am doing some analysis for a company and they are considering setting an
>internet service to do reporting on some basic transaction like data. The
>data is being received by files and consists of around 6 fields taking up
>80
>bytes.
>
>So far no problem but here's the catch. According to their sizing
>spreadsheet they want to process 8,000,000 transactions a day. I would
>expect the requirement to be for 12 months of data to be stored on-line for
>ad-hoc querying. Along with the hugh data table there will be lookup tables
>and some user administration tables but nothing big.
>
>Have anyone ever come across databases this size and is it in the realm of
>the unreasonable. I would be assuming that you might be able to use
>SQL*Loader to bulk load data.
>
>Anyone any advice / tips or suggestions ?
>
>thanks
>
>Paul
>
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Oracle LazyDBA home page