Re: Size of database

On Tue, 12 May 1998 23:14:38 GMT, cmohan_at_iname.com <cmohan_at_iname.com> wrote:
>If your question is specific to paramters in INIT.ora file, the small, medium
>and large refer to the number of users, rather than the datafile sizes!

Actually, they refer to the SGA size:

# Some parameter settings are generic to any size installation.
# For parameters that require different values in different size
# installations, three scenarios have been provided: SMALL, MEDIUM
# and LARGE.  Any parameter that needs to be tuned according to
# installation size will have three settings, each one commented
# according to installation size.
#
# Use the following table to approximate the SGA size needed for the
# three scenarious provided in this file:
#
#                     -------Installation/Database Size------
#                      SMALL           MEDIUM           LARGE
#  Block         2K    4500K            6800K           17000K
#  Size          4K    5500K            8800K           21000K
#
#

This appears to have been written when 32M of memory was like some kind of big expensive deal. In those days, the memory calculations as described in the installation manuals may have been accurate (although I seem to recall they've always been overly conservative, at least back to O5) to calculate number of users. With the stratification of client/server, the concept of "user" has changed tremendously from the point of view of the server. Size now really refers to the number of objects that users will be accessing simultaneously.

So, I assumed that even if the original poster is talking about polite, he probably still has at least 32M on his PC. So I said, use large, although I could have been more clear than "it depends" wrt size and init.ora. Thank you for doing so.

But we don't even know that that was what he was asking, do we?

>
>CM
>In article <slrn6lh7i3.vl7.joelga_at_pebble.org>,
> joelga_at_pebble.org (Joel Garry) wrote:
>>
>> On Tue, 12 May 1998 07:03:34 -0400, Peter Chan <chanp_at_nortel.ca> wrote:
>> >I have a database that is about 13 Gig in size, what type of database is
>> >this, small, medium or large?
>>
>> If you are asking which parameters to use in the init.ora file, the answer
>> is it depends on your physical hardware, blocksize, and what you are doing.
 

>> Probably large to start out with, and increase some things from there.
>>
>> If you are asking relative to other Oracle sites, small to middlin'.
>> :-)
 

>> >
>> >Thanks a bunch.
>> >
>> >
>> >--
>> >====================================================================
>> >PETER CHAN, Northern Telecom
>> >PHONE: (613) 763-9096 FAX: (613) 763-4408 EMAIL: chanp_at_nortel.ca
>> >====================================================================
>>
>> --
>> These opinions are my own and not necessarily those of Information Quest
>> jgarry@eiq.com http://www.informationquest.com
>> http://ourworld.compuserve.com/homepages/joel_garry
>> "See your DBA?" I AM the @#%*& DBA!
>>
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

-- 
These opinions are my own and not necessarily those of Information Quest
or Pebble In The Sky                     http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.