no of extents for a segment in a locally managed tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: no of extents for a segment in a locally managed tablespace

  1. #1
    Join Date
    Jan 2001
    Posts
    20
    Hi

    If the number of extents allocated to a segment is large (lets say 5000) will there be an impact on performance - I am asking about a segment which is in a locally managed tablespace with uniform extent size. I understand that this is a problem in the case of dictionary managed tablespace.

    Thanks
    Daud

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Allocating extents to an object depends on the importance of the object.Since the object is getting used more keep maxextents very high otherwise low.
    In case of dictionary managed tablespace for extent allocation ...Oracle will have to update the data dictionary but if ur object is in locally managed tablespace then there is no write to data dictionary for extents allocation.The tablespace which houses the object is responsible to maintain information about the extent allocation.
    In locally managed tablespace all information about extents is kept in bitmap table in that tablespace only...so writes to data dictionary is reduced.

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP
    rohitsn@altavista.com

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