Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calculating new tablespace sizes
Hi
About your question to Oracle Group :
Look, you won't find a formal formula to do that. But you can do the
following :
1.- Create a big tablespace only to put all of your table's indexes on it.
This will really improve the performance of your applicactions.
2.- Put this tablespace appart from the "data tablespace".
3.- Create a tablespace to put rollback segment on it, and create 5 o 6
segments.
4.- Create a tablespace to put temporary objects on it.
5.- Separate your tables in three groups depending on their numbers of
rows, for example, rows between 1 and 100000 in group A, between 1000001
and ... and so on. Create a separate user to each one of them and put in a
separate tablespace.
Hope this help you.
Andy Hardy wrote:
> Hi,
>
> We have a database with a single large tablespace.
>
> We'd like to rebuild the database, but use more tablespaces for simpler
> admin.
>
> Is there and easy way of calculating tablespace requirements based on
> existing table definitions and sizes?
>
> Andy
>
--
"Smell the Flower While you can"