on 04-15-2016 8:31 AM
Hello togehther,
we've a great amount of large LOBSEGMENTs in our Oracle Database.
For example
SYS_LOB0000013822C00007$$ Sizes: 53.942.464 KBytes
SYS_LOB0000013872C00006$$ Sizes: 15.286.464 KBytes
Question is:
How can I shrink (reduce space ) these Segements?
We have Oracle 12.1.0.2.0
Best regards,
Mathias Schneider
Hi,
Have a look at SAP KBA 2142497 - What to do for large lobsegment on Oracle database?
Hope this will help you.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mathias,
You need to find the corresponding table or index from dic dba_lobs.
Afterwards please table reorganize or index rebuild to shrink these segments.
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.