Thursday, 19 May 2011

Truncate composite instances

Time to time DB is too big on DEV/TST environment. Work stops and everything takes too much time.
Solution:
1. Login as DEV_SOAINFRA;
2. Execute script:

begin
  soa_fabric.deleteCompositeInstances('composite_instance');
end;

All instance history will be gone.

No comments:

Post a Comment