Comment in-line
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____USA__________November 7/9 (MI), 19/21 (TX)
____England______November 12/14
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
tingl wrote in message ...
>
>First of all, number of concurrent users does not necessarily show
>scalability.
>There are other variables in the equation as well. Assuming you are
>running 32-bit Intel platform, your SGA size can be at most about 3G
>which is a major limitation for large databases.
Eeee - luxury ! (Yorkshire accent required).
When I were a lad, I built me fust Terabyte database
on a machine wi' nobbut 2GB total RAM.
Youngsters these days just don't know how
lucky they are !
>If you think 3G of SGA is enough for your 500G database and future
>growth, by all means go with 32-bit Wintel. Otherwise
>industrial-strength UNIX is the best choice.
On a more serious note - it is perfectly feasible to run 500GB of
database on 1GB of db_block_buffers, 200MB of shared pool,
and 20MB per user for a total of 90 concurrent Oracle processes
before you hit the crunch 3GB (which I believe is for all threads
under the Oracle process, not just the SGA - but I may be wrong).
Large volumes of data do NOT automatically require enormous
volumes of memory. For data warehouse systems, precision
and disk response times are frequently much more important.
Received on Tue Oct 01 2002 - 11:28:29 CDT
