Re: Improving performance of working tables

Helo,

You could consider to use the UNRECOVERABLE option. This option will not create redo-log information.

f.e.
insert into emp2 select * from emp unrecoverable;

jobrien99_at_my-deja.com wrote in message <7vvuk7$irj$1_at_nnrp1.deja.com>...
>
>
>To increase the performance of a table that undergoes high transaction
>volume ( batch rates ) what way can this table be created in Oracle so
>that it has no recovery overhead.
>
>These types tables can easily be created from existing data on failure,
>they just get cleared out and the job is rerun.
>
>For example they don't need rollback, in fact they don't need redo.
>Discrete transaction would be fine ( maybe too many block are modified,
>is this a restriction still ?).
>
>Temporary tables could be used but they are session based,
>unfortunately.
>
>Basically the fastest way to set up a table that has data read and
>written to it and the table is considered 100% recoverable so no
>contingency is required for it. How would you set it up ?
>
>Regards,
>John
>
>
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sun Nov 07 1999 - 04:31:17 CST