Peter <peter_at_nomorenewsspammin.ca> wrote in message news:<80l0cvcep7bfvplq5gbmh4hqp2ivvhh35q_at_4ax.com>...
> If I set the UNDO_MANAGEMENT=AUTO init parameter, Oracle is supposed
> to manage undo automatically. So if I create a tablespace, do I still
> need to include the "SEGMENT MANAGEMENT AUTO" clause?
>
>
> Thanks
You mean "segment space management auto"? You are confusing AUM
(automatic undo management) with ASSM (automatic segment space
management). AUM means you want ORACLE to manage undo segments
automatically for you. ASSM means ORACLE will manage the free space of
segments in the tablespace using a bitmap, as opposed to free lists.
You can not specify ASSM with an undo tablespace at all.
Received on Tue May 13 2003 - 00:26:48 CDT
