-
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
-
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
-
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.