Re: Size estimation
Date: Mon, 22 Feb 2021 16:44:49 +0000
Message-ID: <DB7PR10MB209054E1F5AAA1021E83CD2E85819_at_DB7PR10MB2090.EURPRD10.PROD.OUTLOOK.COM>
This discussion reminds me of the first DBA course I attended back in 1989 I think. Not for Oracle but for IBM SQL/DS (the forerunner to DB2)
At a time when disk space really was at a premium (we had just bought 21GiB, 2nd user, for £500,000), part of the course was sizing, and we sat doing lots of careful calculations to get exact row sizes - taking into account length bytes and all that fiddly stuff. Really detailed, getting a very carfully considered size for tables and indexes, and the instructor said
"OK, now take what you've got and double it. you always run out of space quicker than you think" - spend hours calculating exact sizes and then add 100%.
I've sized systems the same way ever since. Work out what you need. Double it. Convince someone they need to pay for it.
Neil Chandler
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Jonathan Lewis <jlewisoracle_at_gmail.com> Sent: 22 February 2021 15:42
To: Pap <oracle.developer35_at_gmail.com> Cc: Lothar Flatz <l.flatz_at_bluewin.ch>; jack_at_vanzanen.com <jack_at_vanzanen.com>; Mark W. Farnham <mwf_at_rsiz.com>; Oracle L <oracle-l_at_freelists.org> Subject: Re: Size estimation
A couple of points to watch out for - again related to a small model for a big object.
Are you counting leaf blocks in the index to get 4MB or looking at the size of the segment ?
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 22 2021 - 17:44:49 CET