Re: Which value for INITRANS ?

No, don't set it to "number of rows per block ?"

INIT_TRANS is the number of transactions entries to pre-allocate in the block headers. Use the default - also for MAX_TRANS. If you had an OLTP system with many active transactions on the same blocks you might want to pre-allocate more space in the headers, but for dw databases this is rare. Remember, transaction entries will still be created (and not de-allocated) in the data area of the data blocks up to the value of MAX_TRANS if needed - which in your case they probably won't be.

MotoX

Philippe Gaudin wrote in message <6ofpqh$dg1$1_at_alpha1.isabel.be>...
>Hi everybody !
>
>We have here an Oracle database for which we want to transfer all
>modifications to our data warehouse.
>
>To do that, we have created a DWHOUT schema (with one table per main
>database table) in which the created, modified and deleted data are saved
>using triggers.
>
>On a regular base the data of DWHOUT are transfered to our data warehouse
by
>selecting, inserting (in data warehouse) and deleting all the rows of each
>table.
>
>So each row of a DWHOUT table is inserted then later selected and deleted.
>
>In this context, how to compute a good value for the INITRANS ? INTRANS =
>number of rows per block ?
>
>Thanks in advance.
>
>Philippe.
>
>
>
>
Received on Wed Jul 15 1998 - 04:16:52 CDT