Extent Management - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: Extent Management

  1. #21
    Join Date
    Apr 2006
    Posts
    377
    Yes, but even with DICTIONARY managed tablespaces INITIAL could equal NEXT. Even with LOCALLY managed tablespaces INITIAL doesn't always have to equal NEXT.

  2. #22
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    but if initial = next then you dont really have a major problem and space will be re-used

    and no in an LMT they dont have to match - but then you know that it was created properly in the first place. If looking at an old DMt i'd definitely look there

  3. #23
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    i think the answer which sums this all up is move all the objects as you said anyway.

    Thats the only way you get all the benefits

  4. #24
    Join Date
    May 2006
    Posts
    8
    Thanks ebrian

    It works :

    select a.owner, a.segment_name, a.segment_type
    from dba_segments a, dba_tablespaces b
    where a.tablespace_name = b.tablespace_name
    and b.extent_management = 'LOCAL'
    and b.allocation_type = 'USER';

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