segment space management manual
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: segment space management manual

  1. #1
    Join Date
    Oct 2006
    Posts
    2

    segment space management manual

    Hi,

    In our database , tablespace is having extent management local & segment space mgmt manual.
    Do it degrade performance of DB?
    Undo & temp tablespaces are also having same extent & segment mgmt.
    Create another tablespace having segment space mgmt auto & transferring objects in it will improve performance or not?
    please advise.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    yes
    no
    maybe
    depends

    will be one of those - what are the current performance issues you are seeing in your database right now. Do you understand what ASSM is?

  3. #3
    Join Date
    Oct 2006
    Posts
    2
    Hi,
    Thanks for for reply.
    Presently I am getting buffer busy waits on 2 tables which are persent in tablespace having segment space mgmt manual.
    I have read somewhere that buffer busy waits reduce if segment space mgmt is manual.
    & Undo & temp tablespace are having segment space mgmt manual. Right?

  4. #4
    Join Date
    Sep 2006
    Posts
    2
    Hi,
    One of many reason for buffer busy wait is "freelist". What kind of operation happens on this two objects? Is it mostly insert? If so, why not you manually create the few more freelist for these objects and see if helps.
    If creating freelist help, then plan to move your tablespace to ASSM.

    Regards,
    Satheesh Babu.S
    Bangalore.

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