Re: planing tablespaces - please comment

Hi Rahul,

This is always recommend by expert. I attended many conferences, speaking of tablespace management. This is right approach.

Joan

Rahul wrote:
>
> List,
> please comment
>
> i do the following when planing tablespaces for the schema
>
> 1) divide all tables into three categories small, medium, large
> according to the estimated data volume
>
> 2) create 3 tablespaces to hold the above 3 kinds of tables.
> data_small,
> data_med,
> data_large
>
> all tablespaces are created with uniform extent size (8i)...
> example:...
>
> data_small extent uniform size 32K
> data_med extent uniform size 1M
> data_large extent uniform size 25M
>
> i keep the max number of extents to around 30, if a table exceeds that
> limit then i move the table to the higher level tablespace
>
> i apply the same logic to indexes also...
>
> is the right way to plan tablespaces ?
>
> TIA
> Rahul
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> 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).
Received on Thu Oct 05 2000 - 09:02:52 CDT