===
I am having many tablespaces as LMT with Segment Space Management as manual . Want to change this to auto.
As far as i know u can't alter a tablespace for segment-space management=auto for existing tablespace.
One of the option may be
creating new tablespaces and moving the objects to new tablespace.
But i think lot of works needed to do this operation considering the my db is large one and having many tablespaces
any idea ?
===
According to my benchmark test, ASSM did not otperform MSSM as many of us thought. If you manage FREELISTS and INITRANS for the objects stored in LMT, my advie is to continue to do so. But you have 3rd party application and do not know how many transactions concurrently executed, may be you switch over to ASSM.
Stick shift car will always outperfm AUTOMATIC transmission.
Tamil
