In rz20 showing red

[Former Member]

Hi,

My db is oracle with linux.In rz20 -- database-oraclesegmentsin that mostallocated extents in any segment- 244 is showing red.how to rectify this problem.

Thanku

[Former Member · Accepted solution]

Hi Kumar,

The "Red" Coloured line is apprearing for "Most allocated extents in any segment" because at least one segment has a number of extents exceeding the threshold. You can check the threshold set for your system by selecting "Most allocated extents in any segment" and clicking on properties.

The best way out to rectify this problem is to do a reorganization of the table(s) contained in this segment.

Regards,

Deoraj Alok.

[Former Member · Accepted solution]

Hi Deoraj,

We are facing the similar issue , with  LOB SEGMENT

2.292  SAPSR3 SOFFCONT1.SYS_LOB0000899757C00007$$

I think , online re-org is tricky for LOB SEGMENTS , i am not sure. Please suggest me how to proceed.

Regards,

Balaram