Database Administration (MOSC)

MOSC Banner

Defragmentation of LOB segment

edited Oct 10, 2012 10:08PM in Database Administration (MOSC) 6 commentsAnswered
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
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center