Skip to Content

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

Most allocated extents in any segment oracle 11g

Hi,

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.

Regards,

Balaram

Former Member

Helpful Answer

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