Re: DB sizing - whitepaper

Bjørn
What you say is true. Now my question is What should be the answer to the question "How you plan the Database sizing for a given application?". I faced it in a DBA interview. I did mention about the requied tablespaces, storage parameters etc depending on Application size. Am I missing something? Seniors, please advice.

Regards,
Ramesh D Papnoi
Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer) http://www22.Brinkster.com/rpapnoi

• Original Text ----------

To: internet["Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>]

Ramesh,

I presume you are looking for something to tell you how to configure a database server, and such a thing does not exist. Period.

The real answer is, that this is far too application dependent, and that only the application developers can provide anything of this kind. And even in this case, such configuration guides are often more misleading than guiding. There have been attempts at making rules like "this application is like X tpc-c transactions", but they also fail to be of any actual value.

Also, if what you really were looking for was something to tell you the size (in GB) of the required disk to store schema with a certain definition, you could create some rough estimates. However, with todays typical disksizes, you run out of spindles much before you run out of GB.

Thanks, Bjørn.

rpapnoi_at_chemtex.co.in wrote:

>Hi Gurus,
>Can anybody mail me the the whitepaper/policy document on database sizing?
>Thanks in advance.
>
>Regards,
>Ramesh D Papnoi
>Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India
>(BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer)
>http://www22.Brinkster.com/rpapnoi
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?ISO-8859-1?Q?Bj=F8rn?= Engsig
  INET: bengsig_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: rpapnoi_at_chemtex.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).