max free blocks alerting
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: max free blocks alerting

  1. #1
    Join Date
    Sep 2001
    Posts
    200
    I have some scripts that monitor space usage. Now there is one that alerts as below.

    "Max free blocks alerting - CCSP212-PROD Production"

    TABLESPACE_NAME Max free (KB) Max next (KB) free - next
    ---------------- --------- ---------- ---------
    I_ENCNTR_PRSNL 47272 26248 21024

    #########################
    I have the following questions
    1/ What does this mean?
    2/ How do I solve it?

    I have included some general stats on the tablespace below

    TABLESPACE_NAME FILE_NAME FREE(KB)
    --------------- --------- -----
    I_ENCNTR /dev/rprod_0132 400
    I_ENCNTR /dev/rprod_0032 31736
    I_ENCNTR /dev/rprod_0128 46096
    I_ENCNTR /dev/rprod_0096 47272


    SEGMENT_NAME TOTAL(KB) NEXT(KB) EXTENTS
    ------------ --------- ------- -------
    XPKENCNTR 44696 11664 11
    XIE2ENCNTR 70320 17496 15
    XIE3ENCNTR 66144 17496 15
    XIE4ENCNTR 82424 26248 15

    Thanx




  2. #2
    Join Date
    Mar 2001
    Posts
    314
    The way I understand it, you have 47MB free, the table/index with the largest NEXT (storage parameter) value has it set at 26MB and there is NOT ENOUGH CONTIGUOUS SPACE in your tablespace for allocation of the same! Your tablespace has a max contiguous free space of 21MB.

    Add more space to your tablespace:

    ALTER TABLESPACE i_encntr_prsnl ADD ............. SIZE ......;

    -amar

  3. #3
    Join Date
    Sep 2001
    Posts
    200
    Thanks Amar,
    I had added more space and coalesced as well but it didn't work. However your analysis gave me a good picture of what is going on. So I opted for a working-around. I modified the storage param (next) to 16M instead of the 26M. There should be enough contiguous 16M.
    Thanks so much.
    Life is what is happening today while you were planning tomorrow.

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