Re: V7 db size
Date: Tue, 13 Dec 1994 22:06:39 EST
Message-ID: <1994Dec13.220639_at_ynp.dialup.access.net>
In article <3cjdro$mgu_at_cougar.vut.edu.au>, leng_at_cougar.vut.edu.au (Leng Kaing)
writes:
|>
|> Hi everyone,
|>
|> Can someone please tell me the default database size in terms of
|> datafiles, SGA, shared pool etc for Oracle 7? We're planning on
|> upgrading to 7.1.3. (is this the latest?) and hope to be working around
|> the default (small?) size. Is this a good idea? We may have ~300
|> students on the database. So we need to know how much space is involved
|> and perhaps upgrade hardware (if necessary) before February.
Although it's not clear why does default DB size matter for you if you're gonna work around it anyway, and moreover you should determine DB size based on *your* requirements and not on what's offered for some "generic" installation, these are approximate figures for SCO UNIX/ODT based Oracle 7 (sorry I can't recall exact values, but they're pretty close):
system ts 25 Mb tools ts 15 Mb temp ts 0.5 Mb users ts 1 Mb rbs 5(?) Mb redo logs 1.5 (0.5*3) Mb
But this is a bare minimum, it doesn't assume you'll be able to install Motif-based stuff like CASE/Forms4 or things like Oracle Office Server!
As to SGA (which includes shared pool, doesn't it?), there're values for three database system models predefined in init.ora: small, medium and large. Those figures must look like 3.5M, 6 and 9, but normally you'll want to assign to SGA as much RAM as possible (maybe 15% to 30% - depends on total available memory).
Sure numbers are varying from platform to platform, but it might give you a picture.
+-----------------------------------------------------------------------------+| Youri N. Podchosov (ynp) *** Davidsohn & Son, Inc. NYC *** 718-234-4140 | | Internet: ynp_at_ynp.dialup.access.net CIS: 72723,2202 AOL: ynp, yourip |
+-----------------------------------------------------------------------------+Received on Wed Dec 14 1994 - 04:06:39 CET