Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.



Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question