segment space management manual
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?
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?
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?
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.
Click Here to Expand Forum to Full Width