Re: Sizing spreadsheets

Hello!

What version of Oracle are you using? If you are using 7.3 or higher, then you really don't need to explicitly size each table and index extent. All segments (tables, indexes, rollback segments, temp segments) can be set to unlimited extents (which is actually something like 2.1 billion). Oracle recommends picking a "reasonable" extent size (we use 100K) and stick with it for every segment. This way, you eliminate the need to do reorgs because a standard extent size is tremendously more likely to be reused after being deallocated. It works for us. I haven't had to do a reorg in over a year!

If you are trying to estimate what the sizes will be (for disk purchase, etc.), then simply look at the size of the source data, or make a reasonable guess about the size and number of rows (then double it!).

Good luck,
Dave

reddyv_at_my-dejanews.com wrote in message <6lra78$6bi$1_at_nnrp1.dejanews.com>...
>Hi! I am looking s spreadsheet(s) that can help me estimate space
>requirements for tables and indexes. I am sure a lot of people must have
done
>it already and I would like to avoid re-inventing the proverbial wheel. If
>anyone knows any web site where I can find one or if someone can send me a
>copy I would greatly appreciate it. Thanks Venkat
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon Jun 15 1998 - 22:08:46 CDT