Re: How can create a BIG TABLE

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 - 03:58:57 CST