next_segment bigger that the available space
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: next_segment bigger that the available space

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Cool

    Hi !

    Somebody has some script that it shows to all the objects to me that are with the size of next_extent bigger that the available free size in tablespace.

  2. #2
    Join Date
    Mar 2001
    Posts
    12

    RE: next extent bigger than available space

    You can create a view like

    CREATE VIEW dba_tbs_free AS
    SELECT tablespace_name,
    max(bytes) max_free_extent
    from dba_free_space
    group by tablespace_name
    /

    then issue following query to get those objects

    SELECT a.tablespace_name,
    b.max_free_extent,
    a.owner,
    a.segment_name,
    a.segment_type,
    a.next_extent
    FROM dba_segments a,
    dba_tbs_free b
    WHERE a.tablespace_name = b.tablespace_name
    AND a.next_extent > b.max_free_extent
    /



    good luck

    Tang Qiang

  3. #3
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    Try this

    select tablespace_name,owner,segment_name,segment_type,
    next_extent from dba_segments;

    Good Luck.



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