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.
