Segment Space Management auto

[mdash]

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 ?

[hrishy]

Hi

If you see a benefit which significantly impacts your business in a positive way then go do this excersis else why even bother about it ?

every release of software has some features doesnt mean you have to use it ..(strange but whether you like it or not you got to pay for it :-D)


regards
Hrishy

[mdash]

yes there will be performance improvement.
if we will use LMT with segment management as auto then recursive cpu usage will be reduced .

[davey23uk]

that isnt necessarily true - tune your freelists correctly

[kris123]

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

[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

[kris123]

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

[hrishy]

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..



regards
Hrishy

[reydp]

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.

[hacketta1]

Howard Rogers' e-book 9i New Features contains a good discussion of the pros and cons of ASSM and at $5.95 (USD) it's a bargain!

http://www.oreilly.com/catalog/oracle9ipdf/