Segment space management to auto
CKPTJul 15 2010 — edited Jul 17 2010Hi,
Db version: oracle enterprise edition 10.2.4.0 64 bit
Os version: windows 2003
The tablespaces of my database is in segement space management "manual" . so if i want to conver the segment space management to "auto".
Automatic :- Objects in the tablespace automatically manage their free space. It offers high performance for free space management.
Manual :- Objects in the tablespace will manage their free space using free lists. It is provided for backward compatibility.
1) so how can i find out whether database is in backward compatibilty?
2) is there any issues with performance after converting
3) or is there any other severe issues other than performance.
4) how can we identifiy the difference interms of performance after migrating from "manual" to "auto".
Thanks.