Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Possible to use ASSM for the SYSTEM tablespace ?

JhilSep 5 2015 — edited Sep 6 2015

Why Oracle not enabled ASSM in system tablespace ?

Docs clearly said , NOT possible to enable ASSM in system tablespace. Any specific reason ?

I see production data is maintained in system tablespace also.

SYS>SELECT tablespace_name, extent_management, segment_space_management FROM dba_tablespaces;

TABLESPACE_NAME EXTENT_MAN SEGMEN

------------------------------ ---------- ------

SYSTEM LOCAL MANUAL

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 4 2015

Added on Sep 5 2015

#general-database-discussions

12 comments

1,602 views