No. Extent sizes should be consistent within the tablespace. So if you're
going to change it to 100M, start with 100M, and increase MINEXTENTS to be
160.
Regards
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"mtbe" <tahar.bellem_at_ctrceal.caisse-epargne.fr> wrote in message
news:a6kji6$uk9$1_at_s1.read.news.oleane.net...
> Thanks a lot for your answer.
>
> So can i create my table PG_transaction in dedicated tablespace
> TBS_TRANSACTION (18 Go sized) with the following storage parametres:
>
> CREATE TABLE PG_transaction
> (
> ...
> ...
> )
> STORAGE
> (
> MINTEXTENT 8
> INITIAL 2000M
> NEXT 2000M
> PCTINCREASE 0
> )
> TABLESPACE TBS_TRANSACTIONS
> ;
>
> Once the table is created (8 * 2000 Mo) , i change the NEXT to 100M in
order
> to find
> easily continous blocks if the table grows.
>
> Is it the best way to do ???
>
> Thanks.
>
>
>
> Sybrand Bakker a écrit dans le message ...
> >On Fri, 8 Mar 2002 09:48:12 +0100, "mtbe"
> ><tahar.bellem_at_ctrceal.caisse-epargne.fr> wrote:
> >
> >>Hello,
> >>
> >>Can anyone say me which value of INITIAL_EXTENT,
> NEXT_EXTENT,MINEXTENTS,...
> >>should i set to create the table PG_transaction ?
> >>What could be the impact in performance to choose a big NEXT_EXTENT
(like
> 2
> >>Go) ?
> >>
> >>Oracle : 8.1.7
> >>TableName : PG_transaction
> >>RowSize : 677 Octets
> >>Nb ROWS : 20 000 000 Rows
> >>Acces : Insert/Delete/Update/Select
> >>Blocksize : 4K
> >>Kind Application : OLTP
> >>
> >>
> >>Thanks for your answers.
> >>
> >>
> >The formula should be to calculate the size of your table should be
> >listed in the Oracle DBA manual.
> >Other than that TOAD has an option to estimate the table size.
> >
> >The impact in performance of choosing a big extent would be exactly 0,
> >and most likely detrimental to performance, especially when using
> >dictionary managed tablespaces. How do you think the kernel is going
> >to find 2G contiguous?
> >
> >Regards
> >
> >
> >Sybrand Bakker, Senior Oracle DBA
> >
> >To reply remove -verwijderdit from my e-mail address
>
>
Received on Tue Mar 12 2002 - 13:23:05 CST
