Defragmentation of LOB segment
Hi
I have few queries related to defragmentation of LOB segments
1) What is the preferred way to defrag a LOB segment. We have to plan for defrag of on LOB segment which has current size is 300 GB while actual space is 75 GB.
Can I use the following command
I have few queries related to defragmentation of LOB segments
1) What is the preferred way to defrag a LOB segment. We have to plan for defrag of on LOB segment which has current size is 300 GB while actual space is 75 GB.
Can I use the following command
ALTER TABLE <table_name> MODIFY LOB (<lob_column>) (SHRINK SPACE);
I believe this can be executed online.
2) Would it cause any issue in performance on the existing operations which would use this LOB segment
3) Any bug/s associated with this operations
4) How efficient this command
Rgds
Harvinder
0