Most allocated extents in any segment oracle 11g
We are getting many ccms alerts related to "Most allocated extents in any segment". a LOB SEGMENT has many extens almost 2292.
Please find the below details.
2.292 SAPSR3 SOFFCONT1.SYS_LOB0000899757C00007$$ LOB SEGMENT
Could you please sugget me, how to resolve these type of segment issues as well as , how to decrease the extents on fly.