brconnect -f check output description

[Former Member]

HI,

can someone give me example of output of brconnect -f check related to CRITICAL_SEG check and database administration alert generated if number of next_extents that can be allocated in tablespace where object reside is smaller than threshold that is set in DB17.

In my logs of brconnect -f check run I have:

........

4 Y W CRITICAL_SEGS

Segment can cause tablespace overflow - by allocating up to 5 next extent(s)

.......

........

but I can not find what an output should look like in case alert is generated. Can you share an example (it would be the best if I would have a link to documentation where BRCONNECT alerts are described and example given - I have already checked notes 442395, 655162 as well as BRTOOLs libraries, but was not able to identify required info)

[Former Member · Accepted solution]

Hi,

Not sure if this is what you are looking for but:

Description 
[...]
  5   Y    W   CRITICAL_SEGMENT                                         
Segment can cause tablespace overflow - by allocating up to 2 next extent(s)                                                                    
[...]
BR0970W Database administration alert - level: WARNING, type: CRITICAL_SEGMENT, object: (cluster) SYS.C_OBJ#_INTCOL#, value: 2488576 KB * 1 / SYSTEM (> 2047992/2046384/1636624/550320/489880 KB)

Here we can see the following information

1) the object -> <b>SYS.C_OBJ#_INTCOL#</b>

2) Next extent of this object -> <b>2488576 KB</b>

3) Tablespace -> <b>SYSTEM</b>

4) Contiguos free space on the tablespace -> <b>2047992/2046384/1636624/550320/489880 KB</b>

As you can see, the next extent for this object is <b>2488576</b> but Oracle will not be able to allocate it on the avalable contiguous free space on the tablespace:

2488576 KB > 2047992 KB

2488576 KB > 2046384 KB

2488576 KB > 1636624 KB

2488576 KB > 550320 KB

2488576 KB > 489880 KB

In this case it is not able to allocate 1 next extent.

Imagine that the free space would have been

(> 3047992/2046384/1636624/550320/489880 KB)

In this case Oracle will be able to allocate one extent

2488576 KB < 3047992 KB

but still will not be enough space for the second.

I hope this explanation clarifies the question