Re: DB sizing - whitepaper

2002-02-14 Thread Bjørn Engsig
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

Re: DB sizing - whitepaper

2002-02-14 Thread rpapnoi
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

Re: DB sizing - whitepaper

2002-02-14 Thread Bjørn Engsig
Ramesh, I still don't know exactly what you mean by 'database sizing'. If what you really mean is 'disk capacity', the most important factor today is the number of I/O's available on your most active tablespaces and the redo log files. Frequently, you end up with a situation, that your disk

Re: DB sizing - whitepaper

2002-02-14 Thread david . m . harris
How you plan the Database sizing for a given application? Ramesh, They may have been looking for a more obvious response, like starting with the type of application rather than its size; I'm familiar with transaction processing systems (ie, an ATM) and decision

Re: DB sizing - whitepaper

2002-02-14 Thread rpapnoi
Bjørn David Thanks for your replies. In reply to the question How you plan the Database sizing for a given application?, I answered and explained about the application development from preliminary study to final implementation. which covered creation of schema,tablespaces,objects,storage

DB sizing - whitepaper

2002-02-13 Thread rpapnoi
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 --