Conference eps::oracle

1528.0. "Oracle sizing question!_" by OSLLAV::BJORNAU (Bjorn Austrheim, Sales Support, Norway) Thu Mar 13 1997 03:09

    Hi!
    
    Have asked this question in the Datawarehouse-notesfile, but got no
    replies. Time is running, so i'm crossposting it here too!
    
    Regards
     
    
    Hello!
    
    Got contacted by a consultancy company who is answering a DW-bid.
    The solution is based on Oracle, choice of UNIX or NT.  (have suggested
    UNIX so far)
    
    Not a large solution compared to some the discussions in here about TB
    databases, but still we need some help sizing  a configuration.
    
    The data we've got so far:
    
     - 75 mill  orderlines
     - 1.4	mill lines of invoices
     - 20000  	lines of resellers
     - 9000    	lines of number of articles
     - 14000  	lines of articles_sold
     - 2.7 	mill  lines of reseller_sold
     - 10       suppliers
    
     - load 500.000 lines once a week
     - 10 concurrent users
    
    The customer anticipate this to be max 30 GB, the consultancy company
    anticipates it to be 50 GB.
    
    They have defined lots of queries and reports against this data.
    The require tuning of "normal" reports so that the response time is 3
    sec or
    less.
    
    The consultancy company can design and implement the database  as best
    fit.
    
    I know this might not be enough data to do proper sizing, but I hope
    that you have some suggestions.
    - Is UNIX the correct platform, or is NT ok too?
    - Which server  4*000 or 8*000?
    - Memory?
    - Numbers of CPU?
    - special needs for the I/O-system?
    - Oracle VLM?
    -.....
    
    Thanks in advance
    Bjorn Au!
    Norway