Performance - EBS (MOSC)

MOSC Banner

Shrink FND_LOBS table during production operation

edited Apr 25, 2019 5:00AM in Performance - EBS (MOSC) 4 commentsAnswered

Should I attempt to shrink FND_LOBS table during production operations (24X7) when least activities present?

Will it lock records for POs, GL JE, Invoices, etc.? This operation is estimated to take many hours.

Will it impact performance significantly?

Any throughts on other methods to shrink this historical very large table or optimize it from storage and performance prespective?

The commands:

alter table applsys.fnd_lobs modify lob (FILE_DATA) (shrink space) enable row movement;

alter table applsys.fnd_lobs modify lob (FILE_DATA) (shrink space cascade);

alter table applsys.fnd_lobs modify lob (FILE_DATA) (shrink space compact cascade);

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center