Re: optimize tablespace

First off, placing objects which are production/application tables in the SYSTEM tablespace is a bit risky. You should consider creating a tablespace for both your objects, even splitting up your table and index objects into two different tablespaces thusly:   

   CREATE TABLESPACE <tsname>
   DATEFILE '/usr3/ora_dbf/datafilename'    SIZE 1000M REUSE
   DEFAULT STORAGE(

        INITAL       75M
        NEXT         35M
        PCTINCREASE  10)
        

THEN create a similar tablespace (for index and constraint objects) on a separate device. This cuts down on disk head contention.

When you create your table objects, make sure you use a storage clause with an inital extent that you can place all your inital data into and then choose a next extent size based upon an educated guess as to how fast you think you'll be adding data.

 fon_at_msdos.montpellier.inra.fr wrote:
>
>Hi,
>
>
> In my database, I have 65 tables (all are in the tablespace SYSTEM).
> How optimize my tablespace creating tablespaces ?
> Could you give me an example with this parameters ?
>
> Table name : COUNTRY
> Attributes : CodCountry NUMBER(3) primary key
> NamCountry CHAR(20)
> CodCont NUMBER(2) foreign key
> NamCont CHAR(20)
>
>
> What are the values parameters for the option DEFAULT STORAGE ?
> Values for PCTFREE and PCTUSED?
>
> The good optimisation is to create a tablespace for one table ?
>
>Thanks for your response.
>
>
>Please reply by E-Mail :
>E-Mail -> lafon_at_msdos.montpellier.inra.fr
Received on Tue Jul 25 1995 - 00:00:00 CEST