What are the advantages of managing space using automatic segment space managed objects?

Interview Candidate
Oct 2nd, 2004
2
1208

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

kunal1017
Profile Answers by kunal1017

Aug 28th, 2008

The automatic space management is enabled by using SEGMENT SPACE MANAGEMENT AUTO clause in create tablespace statement. It uses the bitmap segments to keep track of used and free space in segments for particular tablespace. So whenever space is allocated or deallocated the bitmap segment is updated. It does not cause update operations on undo segments and data dictionary tables. So contention for dictionary is reduced.