Segment Space Management auto
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 43

Thread: Segment Space Management auto

  1. #1
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63

    Segment Space Management auto

    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 ?

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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

  3. #3
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    yes there will be performance improvement.
    if we will use LMT with segment management as auto then recursive cpu usage will be reduced .

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    that isnt necessarily true - tune your freelists correctly

  5. #5
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    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

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  7. #7
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    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
    Last edited by kris123; 05-11-2005 at 06:36 AM.

  8. #8
    Join Date
    Jan 2001
    Posts
    2,828
    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

  9. #9
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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.
    Last edited by marist89; 05-11-2005 at 02:12 PM.

  10. #10
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    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/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width