Improving performance of working tables

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 Fri Nov 05 1999 - 19:00:56 CST