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
Originally posted by mdash yes there will be performance improvement.
if we will use LMT with segment management as auto then recursive cpu usage will be reduced .
Hmm..i doubt how much you would really gain with that.
Did you ever think about the effort vs the gains ?
on the freelist part also you can just alter it no rebuild etc required.
its your call finally..but you say the database is big..whateevr you do make sure you have a timeframe and a recovery window large enough to restore make yourself comfortable..
Originally posted by davey23uk RAID 5? for write intensive application? ummm yeah ok.
If you don thinks freelists are important in you are inserting thousands of records a seconds then you dont know what you are talking about
Davey,
Anyway, Raid 5 in an external storage with high memory cache can manage thousands of records as if it is an ordinary disks.
But still I agree with the freelist configuration though.
Reply With Quote
Of couser be sure u have a good size memory and
Bookmarks