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
Hun, just remember 1 thing. Believe me, to attain a good performance
just tune the apps(sql statements) and place ur data on raid+5
striping, then u will live happily ever after. All the rest are not
so important. Of couser be sure u have a good size memory and
at least dual processor and preferably unix boxes
Well what we are all concern with and need to be satisfied are the
OLTP end users who will rate ur apps to be good or bad.
Most of them process one record at a time. Those who insert and update lots of rows must run their jobs at graveyard shift