DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: INDEX LOW ON SPACE OR EXTENTS

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Arrow

    Hi

    How do u find if an Index is low on space/extents?

    Thanks.

    With regards.


  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    first you can look at the ratio extents/maxextents to see if there will be a problem with the number of extents.
    most important thing to do is to look if your index can allocate a next extent, that is to say that there should be enough space in the tablespace and in the datafile(s). like that, and if your objects have been correctly built (acording to the number of rows they should have), you should be quite cool since your indexes won't take many extents at a time, just one, so you can easily anticipate the problems

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Thanks for the reply.

    The ratio of extent/maxextents is ...

    select max_extents from dba_indexes where index_name like 'FND_COLUMNS_U2' and TABLESPACE_NAME LIKE 'APPLSYSX';


    MAX_EXTENTS
    -----------
    50



    select bytes, blocks from dba_extents where segment_name like 'FND_COLUMNS_U2' and tablespace_name like 'APPLSYSX';



    BYTES BLOCKS
    ---------- ----------
    16384 2
    2129920 260
    2129920 260


    So, 3 extents.

    extents 3
    ------------- => ------------ = .06
    maxextents 50


    Total Space in tablespace APPLSYSX is 115 MB with 13 MB free.

    Is this ok?

    Thanks


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